Split a unorganized file

[yoxler]

Hi,

From a internal system I get a file which actually contains two different kinds of data set, here is an example:

FIRST_CASE;543;43f;fds;654;fdsa;20190201122514;654;TEXT;ETC;543.434
SECOND_CASE;20190201122514;HELLO WORLD;1532
FIRST_CASE;543;43f;fds;654;fdsa;20190201122514;654;TEXT;ETC;543.434
SECOND_CASE;20190201122514;HELLO WORLD;1532

Since all attibutes after the first are different I need to put the data in two different files, one with FIRST_CASE and one with SECOND_CASE.

What is the best way to solve this?

[TRF · Accepted solution]

You can use tFileInputFullRow to get each row as a sigle field then separate each record depending on how the line starts (you may use a tMap for that)

[akumar2301]

You could use tFileInputMSdelimited 

[yoxler]

Thank you both!