Hi
Could you tell me the procedure to split csv from a line including a specified text.
Hi
Could you tell me the procedure to split csv from a line including a specified text.
Hi @bigapplerizzi19
Did you try to use the custom transform RegxAttributeSplitter?
Thanks in Advance,
Danilo
Hi @bigapplerizzi19
Did you try to use the custom transform RegxAttributeSplitter?
Thanks in Advance,
Danilo
Hi Danilo,
Thank you for your reply.
I just tried RegxAttributeSplitter.
However it cannot split the csv file at the line containing the specified character.
Best Regard,
Tom
Could you please post a concrete example? If you could post an original line (before splitting) and your desired result (after splitting), it would help us understand your requirement correctly.
Hi,
Maybe I misunderstood "split csv from a line including a specified text " but maybe you could read your file as a Text file with "Read whole file at once" to "yes". Then you can split it to 2 attributes with attributeSplitter, explode the list and write to two text files.