awk - Shell - How to remove a string "EES" from a record after 7th occurrence of colon(:)

Question

how do we remove EES from below input file

{"last_name":"Kiran","first_name":"kumar","sno":"1234","effe??ctive_date":"11/01/2??011","cancel_date":"??12/31/9999","alt_ein??_id_indicator":"Y","??alt_ein_id_employer_??number":"V3EES"} 

Expecting the file after transformation to look like this

{"last_name":"Kiran","first_name":"kumar","sno":"1234","effe??ctive_date":"11/01/2??011","cancel_date":"??12/31/9999","alt_ein??_id_indicator":"Y","??alt_ein_id_employer_??number":"V3"}

TIA

Answer 1

Use jq for parsing JSON data

jq -c '.alt_ein_id_employer_number |= sub("EES";"")' file.json

{"last_name":"Kiran","first_name":"kumar","sno":"1234","effective_date":"11/01/2011","cancel_date":"12/31/9999","alt_ein_id_indicator":"Y","alt_ein_id_employer_number":"V3"}