[krivsonn]

Hi,

I am a translator and have 2 json files given to me from a client. have never worked with such files before and I know nothing about Java.

For some reasons this forum does not allow me to upload this kind of file.

What I need here is a way to extract only text fields required for translation in any format that can be copy-pasted in MS Word in order to perform the word count.

I have found this on Web: https://code.google.com/p/json2txt/ but I couldn't figure out how to use it...

 

This is sample of part of the file edited in Notepad++:

 

{

"additional_info_facebook.birth_year.title": "Birth year",

"additional_info_facebook.cancel.button": "Cancel",

"additional_info_facebook.email.title": "E-mail",

"additional_info_facebook.missing_info.title": "Missing information",

"additional_info_facebook.submit.button": "Submit",

"admin.date_format.credit_card": "MM'\/'yyyy",

"admin.date_format.day_month_year": "dd MMMM yyyy",

"admin.date_format.fullday_month": "EEE'.' dd MMMM",

 

What I am looking for is Birth year Cancel Email etc. each phrase separated with a single space in any format that can be copy-pasted in MS Word.

 

Thank you for your help.

[Advertisements]

You could just upload the JSON file to https://json-csv.com

 

This will separate all the fields into columns.  Then you can dice the data and paste it straight into Word.

[felix1]

You could just upload the JSON file to https://json-csv.com

 

This will separate all the fields into columns.  Then you can dice the data and paste it straight into Word.

[krivsonn]

Thank you for the link,

It is great! At least for the word count. However, that site doesn't offer the opposite conversion, or at least I couldn't find it. I'd like to get this column in excel which is offered there, but after translation, I want to copy paste translation into the column replacing original text in that column with translation and then convert it back into json format to be delivered to the client.

Any suggestions?

 

Davor