topic Re: Manipulate JSON input file to add additional string characters in Talend Studio

Manipulate JSON input file to add additional string characters

Anonymous — Fri, 01 Apr 2016 08:06:02 GMT

I've got an input JSON file formatted as below:

{"column1":"abc","column2":"def"}
{"column1":"cba","column2":"fed"}
{"column1":"123","column2":"456"}

I need to modify it as below:

1.add '' as last string of the last row only

Re: Manipulate JSON input file to add additional string characters

Anonymous — Fri, 01 Apr 2016 11:28:45 GMT

Hi
Use tFileInputRaw to the whole file as a string, and then manipulate the string on a tJavaRow like this:
tFileInputRaw--main--tJavaRow--main--tFileOutputRaw
on tJavaRow:
output_row.content ="";
tFileOutputRaw, generated a new json file based on the updated file content.
Regards
Shong