topic Re: How to output JSON records in multiple rows in Talend Studio

How to output JSON records in multiple rows

Anonymous — Wed, 01 Jun 2016 10:21:28 GMT

Hi Experts,

I have generated a JSON output file using Talend. However, my problem is that all my records are outputted in 1 row in the JSON file. Below is the sample output:

My desired output is to have all JSON record separated by newline in the output file:

Thanks in advance for the feedback and help.

Re: How to output JSON records in multiple rows

Anonymous — Wed, 01 Jun 2016 18:08:28 GMT

replace "}," with "},\n"

Re: How to output JSON records in multiple rows

Anonymous — Wed, 01 Jun 2016 19:34:38 GMT

replace "}," with "},\n"

Thanks for the feedback.
But how do I process JSON file as plain text? When I try to process it, it is always filtered by column. For example, when I try to process the string, records are usually separated by field (field1, field2, field3) and not the whole string ( {"field1":"value1_1","field2":"value2_1","field3":"value3_1"},{"field1":"value1_2","field2":"value2_2","field3":"value3_2"},{"field1":"value1_3","field2":"value2_3","field3":"value3_3"})

Re: How to output JSON records in multiple rows

Anonymous — Thu, 02 Jun 2016 08:26:24 GMT

After you wrote the json file, open it raw (tfileinputraw), read as string, searchn´replace in a tjavarowcomponent, write raw.
Take care about the Encoding

Re: How to output JSON records in multiple rows

Anonymous — Thu, 02 Jun 2016 22:38:23 GMT

Oh dear... string manipulation to transform JSON? Seriously?
Why do you need to pretty print the output this way. For a technical usage of the file this does not makes sense. For the human read you can use tools which formats the file in a human readable way.
I would never ever manipulating the json content which such error prone methods.

Re: How to output JSON records in multiple rows

Anonymous — Fri, 03 Jun 2016 00:57:54 GMT

We really need some sort of +1 or Like mechanism in here jlolling 🙂
I have to say I agree with Jan, but maybe you can explain why you need the JSON in that format ctufindgood? It does seem like a weird requirement, but I have also had many weird requirements from clients 🙂

Re: How to output JSON records in multiple rows

Anonymous — Fri, 03 Jun 2016 09:58:28 GMT

@jolli: hopy you didn´t called me a dear ...

Re: How to output JSON records in multiple rows

Anonymous — Mon, 06 Jun 2016 02:51:49 GMT

Hi jlolling and rhall2.0,
Yes, it is for a technical usage. It needs to accept data in the format of JSON, but the separator (",") actually needs to be replaced by newline character (\n).
Many Thanks.