• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Separating string in one row

#1 2012-06-14 16:09:26

rocknrolla
Member
Registered: 2012-04-15
Posts: 14

Separating string in one row

Hello, i want to ask for more help

I want to separate these string

source: 文献Asian J. Energy Environ., Vol. 8, Issue 1 and 2, (2007), pp. 15-32”Environmental Evaluation of Biodiesel Production from Palm Oil in a Life Cycle Perspective” をもとに作成。

to:

series: 文献Asian J. Energy Environ., Vol. 8, Issue 1 and 2, pp. 15-32

title: ”Environmental Evaluation of Biodiesel Production from Palm Oil in a Life Cycle Perspective” をもとに作成。

year: 2007

all will goes to difference fields, i tried normalize function but it seems only limited to separate using "," or other sign.

Im new to talend, please help me solve this problem


thank you

Offline

#2 2012-06-14 23:34:25

vgalopin
Talend team
Registered: 2009-04-15
Posts: 440
Website

Re: Separating string in one row

Hi,

You have a tStandardizeRow component that allows you to do that, but it's only available in the DQ Enterprise Edition.

If you want something specific like that in TOS, you'll have to code it in Java, using substring and indexOf.


Vincent Galopin
US Pre-Sales Consultant
Talend US

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Separating string in one row

Board footer

Powered by FluxBB