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