topic Re: How to Split more than one field? in Talend Studio

How to Split more than one field?

Anonymous — Fri, 26 Apr 2013 11:54:31 GMT

Hi all,
using tExtractDelimetedFields we split one field at a time.
How to split more than one field?
Regards
Aishu

Re: How to Split more than one field?

Anonymous — Fri, 26 Apr 2013 14:52:58 GMT

Hi
Could you please explain a little more?
The tExtractDelimitedFields will extract as many fields as it can find with the field separator that you specify. Otherwhys you could use a tMap to split this field into more fields using a variable with the java SubString() method.

Re: How to Split more than one field?

Anonymous — Fri, 26 Apr 2013 15:16:37 GMT

Hi DeanWake,
using tExtractDelimitedFields component we split one column at a time.
In component properties list we have option Field to split, here we are given one column at a time.
My requirement is i want to split multiple columns using single tExtractDelimitedFields ?
but there is no option like that in tExtractDelimitedFields component.
Regards
Aishu23

Re: How to Split more than one field?

Anonymous — Fri, 26 Apr 2013 20:09:16 GMT

You can not split multiple columns using tExtractDelimitedFields component. it iwll only work on one column at a time.
However, You can use tMap and use the String.split function on the fields that you want to split into multiple columns.

Re: How to Split more than one field?

Anonymous — Sat, 27 Apr 2013 05:48:38 GMT

Hi vikram,
can you provide sample screen shots for String.split ?
Thanks for you replay
Regards
Aishu

Re: How to Split more than one field?

Anonymous — Sat, 27 Apr 2013 06:09:45 GMT

Its a java function. You can use to split the delimited string into array.
E.g. String varStr = abc@def@ghi@jkl;
String[] strArray = VarStr.split('@');
Now you can use this array with proper index to store the value into columns.

Re: How to Split more than one field?

Anonymous — Sat, 27 Apr 2013 07:46:44 GMT

Hi,
There is a component called tSplitRow, it might address your need, you can always get more precise answers if you explain your request with more details, an example is always welcome.
Best regards
Sabrina