One Star

How to Split more than one field?

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

Re: How to Split more than one field?

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.
One Star

Re: How to Split more than one field?

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?

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.
One Star

Re: How to Split more than one field?

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?

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.
Moderator

Re: How to Split more than one field?

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.