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