Manipulate JSON input file to add additional string characters

Four Stars

Manipulate JSON input file to add additional string characters

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
Community Manager

Re: Manipulate JSON input file to add additional string characters

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
----------------------------------------------------------
Talend | Data Agility for Modern Business