topic Re: Split a unorganized file in Talend Studio

Split a unorganized file

yoxler — Tue, 19 Feb 2019 13:11:06 GMT

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?

Re: Split a unorganized file

TRF — Tue, 19 Feb 2019 13:44:50 GMT

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)

Re: Split a unorganized file

akumar2301 — Tue, 19 Feb 2019 14:24:10 GMT

You could use tFileInputMSdelimited

Re: Split a unorganized file

yoxler — Tue, 19 Feb 2019 14:29:07 GMT

Thank you both!