Add a word to Text file

Shell Programming and Scripting
1

Hello,

I have a mysql text file. I want add word to it. Thanks for help.

Sample sql file:

,'address','166 Warren Street, NY 12534'),(45215,26556,'phone','(518)811-4145'),(151426,15565,'listing_duration','address','122 Hom Street, NY 45623'),(45215,26556,'phone','(518)811-4145'),(151426,15565,'listing_duration'

I want this format.

,'address','166 Warren Street, NY 12534 USA'),(45215,26556,'phone','(518)811-4145'),(151426,15565,'listing_duration','address','122  Hom Street, NY 45623 USA'),(45215,26556,'phone','(518)811-4145'),(151426,15565,'listing_duration'
2

Hi,

What have you tried so far, and what isn't working?

3

Hello,

I don't know shell programming.

6

Let me help you: Shell programming

7

hey,

below command will help you.

 sed "s/NY \(.....\)/NY \1 USA/g" $file
8

Hello,

Thank you very much for this help. but all the addresses(states) are different.

10

If you dont know shell programming you should not post here but in dummies, here is for people who are facing issues with their scripts or programs, and so we expect to see a minimum of code in order to help