Skip to main content
Question

split csv from a line including a specified text

  • March 6, 2020
  • 4 replies
  • 48 views

Hi

Could you tell me the procedure to split csv from a line including a specified text.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

danilo_fme
Celebrity
Forum|alt.badge.img+52
  • Celebrity
  • March 6, 2020

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


takashi
Celebrity
  • March 6, 2020

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.


antoine
Enthusiast
Forum|alt.badge.img+7
  • Enthusiast
  • March 6, 2020

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.