Skip to main content

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.


Reply