Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Extracting text fieds from json file

  • Please log in to reply




  • Member
  • PipPip
  • 48 posts


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.

  • 0




    New Member

  • Member
  • Pip
  • 1 posts

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.

  • 0




  • Topic Starter
  • Member
  • PipPip
  • 48 posts

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?



  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP