BASH Shell Scripting Question

xianzai · 03-18-2004, 06:50 AM

Hi all,

I have shell script that reads in a file, which is a string of text. That text makes up an SQL query later in the script.

How can I add slashes before each apostrophe so as not to make an SQL error?

EG:
This is what it could be....

Code:

MSG="This isn't my message, it's your msg"

This is what I want:

Code:

MSG="This isn\\'t my message, it\\'s your msg"

Just like the PHP function add_slashes()

Any idea anyone?

Thanks!

fsbooks · 03-18-2004, 06:58 AM

Add double backslashes:

$ cat /tmp/slash.bash
mess="This isn\\'t my message, it\\'s your msg"
echo $mess
$ /tmp/slach.bash
This isn\'t my message, it\'s your msg

xianzai · 03-18-2004, 07:18 AM

Sorry, I don't understand what you mean.

I take in args $1 $2 etc

I want to replace all occurences of ' with \'

What does the cat /tmp/slash.bash do in your reply?

Thanks :-)

snacky · 03-18-2004, 07:33 AM

Use:

Code:

sed "s/'/\\\'/g"

to do the text processing.

naflan · 03-18-2004, 02:13 PM

~$ vi name_of_file

in vi type

Code:

:g/\\'/s/\\'/\\\'/g

make sure not in insert mode. If your are, press ESC.

xianzai · 03-19-2004, 07:50 AM

Thanks all, problem solved.