replacing ' with '' using sed


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting replacing ' with '' using sed
# 1  
Old 03-31-2011
replacing ' with '' using sed

Hi,
I have a text file and I would like to replace all occurrences of single quote ' with two consecutive single quotes '' .
I have tried
Code:
sed s/\'/\'\'/ < Folder/outputFile.txt > Folder/otherFile.txt

but this replaces only the first occurrence of ' with ''. I want it to replace all the single quotes in the entire file with two single quotes.
So 'a' should become ''a'' and so on.
Thanks in advance.
# 2  
Old 03-31-2011
Hi.

Use the global modifier:

Code:
sed "s/'/''/g"

Code:
MAN SED
g       Make the substitution for all non-overlapping matches of the regular expression, not just
        the first one.

# 3  
Old 03-31-2011
Code:
echo "'" |sed 's:'\'':&&:'
''

# 4  
Old 03-31-2011
The octal code for single quote is 047. You can use that instead of \' so it won't appear too messy with the quotes
Code:
$ ruby -ne 'puts $_.gsub("\047","\047\047")' file

# 5  
Old 03-31-2011
Thank you very much for the replies. That ( sed "s/'/''/g" ) solved my problem Now I have another problem . I have a file with multi-line text in it. I want the same file to have its entire content surrounded by single quote. So if the file has text
Code:
abcdef
pqrst
uvw

I want it to be
Code:
'abcdef
 pqrst
 uvw'

How can I achieve this? Thank u in advance.
# 6  
Old 03-31-2011
Code:
echo "abcdef
pqrst
uvw" |sed "N;N;s/^.*$/'&'/"
'abcdef
pqrst
uvw'

# 7  
Old 03-31-2011
Code:
$ ruby -0777 -ne 'print "\047#{$_}\047"' file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Not replacing using sed

Hi all, I am trying to change the below word. but the changes is not reflecting in the new file sed -n 's/apple/orange/' filename ---------- Post updated at 12:51 AM ---------- Previous update was at 12:41 AM ---------- I tried this it works perl -pi.bak -e... (9 Replies)
Discussion started by: ramkumar15
9 Replies

2. UNIX for Dummies Questions & Answers

Replacing digits using sed

How to replace a character followed by a digit using sed? For example lets say I have this file - a1 3242134 54235435 3241235 a2 3214345 45325626 3125435 a3 4236577 54365376 6865678 . . . a3000 5432534 32546546 3254365 I want to replace all... (6 Replies)
Discussion started by: saleheen
6 Replies

3. Shell Programming and Scripting

sed not replacing

Data not replacing using sed,please check below. Replace_value=$$dbconn_target Search_value=$$dbcon_source   sed -e s/\${Search_value}/\${Replace_value}/g intrepid_sps_val.parm (2 Replies)
Discussion started by: katakamvivek
2 Replies

4. Shell Programming and Scripting

Replacing using sed

hi Guys, I have a rar file which consists of 10 files. each file has a space in its file name. how can i replace all spaces with _ i can replace them using sed but the thing is i need to replace using a script and not command. can anyone help me out??:confused: (2 Replies)
Discussion started by: rajeshb6
2 Replies

5. Shell Programming and Scripting

replacing by sed

hi my input file has got >,,,, or >, or >,,,,,, there are independent number of commas after >.... i want the o/p as > only that is just to remove "," after">" another is: i want to replace the last line of the file and to replace it by "hello"...how to do?... any nice script plz help (2 Replies)
Discussion started by: Indra2011
2 Replies

6. Shell Programming and Scripting

Need help with SED for replacing an IP

I need some advice to replace 10.183.x.x with 10.174.17.55 in a file containing multiple 10.183.x.x. Any help would be highly appreciated. (1 Reply)
Discussion started by: sags007_99
1 Replies

7. Shell Programming and Scripting

sed inside sed for replacing string

My need is : Want to change docBase="/something/something/something" to docBase="/only/this/path/for/all/files" I have some (about 250 files)xml files. In FileOne it contains <Context path="/PPP" displayName="PPP" docBase="/home/me/documents" reloadable="true" crossContext="true">... (1 Reply)
Discussion started by: linuxadmin
1 Replies

8. Shell Programming and Scripting

SED: replacing

Hello, I was looking around, but could not find the answer, so I hope you ppl can help me. I want simply to replace text.:rolleyes: I found out SED would be good for this task.:b: So I tried: :confused: 1.) find text in a line and replace this particular line: for finding... (3 Replies)
Discussion started by: unknown7
3 Replies

9. Shell Programming and Scripting

replacing using sed

its again sed question. i have line - sed "s/$old/$new/g" "$f" > $TFILE && mv $TFILE "$f" working well if old="myoldfile" new="mynewfile" but if i want old="/home/shailesh/1test/" new="/home/shailesh/workspace/" it gives error like sed: -e expression #1, char 9: unknown option to... (2 Replies)
Discussion started by: shailesh_arya
2 Replies

10. Shell Programming and Scripting

Replacing in SED

I want to change the false in Node 1 to true. How do I do that? <Node1> <Usage>false</Usage> <Url>ABC</Url> </Node1> <Node2> <Usage>false</Usage> <Url>DEF<Url> </Node2> (8 Replies)
Discussion started by: superprogrammer
8 Replies
Login or Register to Ask a Question