topic Re: Split the file and convert to json/xml in Talend Studio

Split the file and convert to json/xml

mani1304 — Mon, 04 Jan 2021 09:15:55 GMT

Hi All,

We have flat files, which have 4 types(A,B,C,D) and B,C,D can come multiple/no times and can have multiple orders, each order ending with

ENDORDER.

Now files

are supposed to

separate each record and after converting it into

json/xml

with base64 encryption need to push into a queue. Now the main problem is coming in converting that thing because we are having multiple/no B,C,D.

e.g.

A|1|2|3|4

B|1|2|3|4|5|6

C|1|2|3

D|1|2|3|4|5

ENDORDER

A|1|2|3|4

B|1|2|3|4|5|6

C|1|2|3

D|1|2|3|4|5

ENDORDER

A|1|2|3|4

B|1|2|3|4|5|6

now it will have 3 orders as below

A|1|2|3|4

B|1|2|3|4|5|6

C|1|2|3

D|1|2|3|4|5,

A|1|2|3|4

B|1|2|3|4|5|6

C|1|2|3

D|1|2|3|4|5,

A|1|2|3|4

B|1|2|3|4|5|6

Can someone please suggest?

Re: Split the file and convert to json/xml

Ravi_Rajagopal — Mon, 04 Jan 2021 14:48:28 GMT

If I interpreted this correctly I think the expectation was

A|1|2|3|4

B|1|2|3|4|%|6

C|1|2|3

D|1|2|3|4|5

Is the above your expectations as well ?

Re: Split the file and convert to json/xml

mani1304 — Mon, 04 Jan 2021 15:08:30 GMT

no, it need to split, whenever an ENDORDER comes and convert that into a json/xml message to push into a UM queue, means output message would be same as input flat file record till ENDORDER, no addition or break.

Hope it clarifies the question.