Add a word to Text file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add a word to Text file
# 1  
Old 01-28-2013
Add a word to Text file

Hello,

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

Sample sql file:

Code:
,'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.

Code:
,'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  
Old 01-28-2013
Hi,

What have you tried so far, and what isn't working?
# 3  
Old 01-28-2013
Hello,

I don't know shell programming.
# 4  
Old 01-28-2013
Let me help you: Shell programming
# 5  
Old 01-29-2013
hey,

below command will help you.

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

# 6  
Old 01-29-2013
Quote:
Originally Posted by srinivas matta
hey,

below command will help you.

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

Hello,

Thank you very much for this help. but all the addresses(states) are different.
# 7  
Old 01-30-2013
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
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Organizing text file by Capital Names (capital word ' ' capital word)

Hi I have a file passwd_exmpl that contains: root:x:0:0:root:/root:/bin/bash bin:x:1:1:bin:/bin:/sbin/nologin daemon:x:2:2:daemon:/sbin:/sbin/nologin adm:x:3:4:adm:/var/adm:/sbin/nologin lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin sync:x:5:0:sync:/sbin:/bin/sync... (5 Replies)
Discussion started by: eladage
5 Replies

2. Shell Programming and Scripting

How to insert a word into a text file?

Hi, I have a text file with one line having few words separated by space and I need to insert another word on "n"th column/field so that previous word should shift right (to n+1st column). how can I do that? It seems we can do using awk but unable to figure out. Please advise, thanks! ... (11 Replies)
Discussion started by: magnus29
11 Replies

3. UNIX for Dummies Questions & Answers

Add a word to Text file

Hello, I have a mysql text file. I want add a word to it. Thanks for help. Sample text: ,'address','166 Warren Street, NY 12534'),(45215,26556,'phone','(518)811-4145'),(151426,15565,'listing_duration' ,'address','233 Tan Street, CA... (1 Reply)
Discussion started by: hoo
1 Replies

4. Shell Programming and Scripting

extract a word from text file name

Hi i want to extract the word present before .txt in the text file. For example, Sample_ab_a.txt ----------> i need 'a' Sample_abc_b.txt -----------> i need 'b' Can anyone help me in getting the word extracted (5 Replies)
Discussion started by: Sindhuap
5 Replies

5. Shell Programming and Scripting

Newb question about getting a word from a text file

Hi everyone. I am new to shell scripting and have been looking at quite a few web pages to try and figure this out, but to no avail. What I am trying to do is get a value from a text file that contains a paragraph of information.. Something similar too: Welcome to random script You are... (1 Reply)
Discussion started by: elemenopee
1 Replies

6. UNIX for Dummies Questions & Answers

how to read the second word of a text file

Folks, how to read the second word of the first line from a text file. Text file does not have any delimiters in the line and has words at random locations. Basically the text file is a log and i want to capture a number that is in second position. Appreciate your help Venu (1 Reply)
Discussion started by: venu
1 Replies

7. UNIX for Dummies Questions & Answers

Script to add text before the first word on a line in a textfile.

How can i make a script to add text before the first word on a line in a textfile : Example: Old line: is my place New line: this is my place Please use and tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks. (3 Replies)
Discussion started by: mjanssen
3 Replies

8. Shell Programming and Scripting

[Bash]Attempting to Merge text from one file into another file at the line directly under a word

Hello, This is my first post on the forums. So I want to start by thanking anyone who is kind enough to read this post and offer advise. I hope to be an active contributor now that I've found these forums. I have an issue that I figure would be a good first post.. I have 2 text files... (5 Replies)
Discussion started by: efciem
5 Replies

9. Shell Programming and Scripting

Can a shell script pull the first word (or nth word) off each line of a text file?

Greetings. I am struggling with a shell script to make my life simpler, with a number of practical ways in which it could be used. I want to take a standard text file, and pull the 'n'th word from each line such as the first word from a text file. I'm struggling to see how each line can be... (5 Replies)
Discussion started by: tricky
5 Replies

10. Shell Programming and Scripting

how to substitute more than one word in a text file?

well i have this file here: <XML> <pregate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <system_c>HPREGATE</system_c> <trans_c>HSPG</trans_c> <trans_dt>20060105161333</trans_dt> <user_id_m></user_id_m> <func_c>C</func_c> </pregate> </XML> i want to... (2 Replies)
Discussion started by: forevercalz
2 Replies
Login or Register to Ask a Question