Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Escape character in sed

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Escape character in sed
Prev   Next
# 1  
Old 12-25-2008
Question Escape character in sed
Hello experts


I am trying to write a shell script which will add ' ' to a unix variable and then pass it to oracle for inserting to a table.

I am running the script as root and I have to do a su -c .
The problem is the character ' is not recognised inside sed even after adding escape character \

Here is my script
----------------------
su - oracle -c '. $HOME/.profile; a=10;quote=`echo a | sed -e s/a/\'/g`;echo $quote;hosted=`hostname`; host=$quote$hosted$quote;

sqlplus scott/tiger <<EOF

insert into unix_box values($host,0,sysdate);
commit;
EOF
'
-----------------------
Error ->
test3.sh: 0403-057 Syntax error at line 1 : ``' is not matched.

How can we add the escape character ' to quot variable .

I am running this script on AIX 5 under shell sh.

Thanks & Regards
Vedaa
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Function to add escape character before specified character

Hi , I am looking for a function which will do the following. 1. I have a variable which will hold few special chracter like SPECIAL_CHARS="& ;"2. I have an escape character. ESCAPE_CHAR="\"3. Now when I passed some string in the function it will return the same string but now it will... (8 Replies)
Discussion started by: Anupam_Halder
8 Replies

2. Shell Programming and Scripting

sed - with escape character

i have string as below str=".<date>" in which i need to replace < with /< , when i tried with sed , got the output. --> echo $str | sed 's/</\\</g' .\<date> when i tried to assign it to a variable , i am not getting the same --> a=`echo $str | sed 's/</\\</g'` ; echo $a... (4 Replies)
Discussion started by: expert
4 Replies

3. Shell Programming and Scripting

sed escape character for comment string "/*"

Good afternoon all, I'm hoping my newbie question can help bolster someone's street_cred.sh today. I'm trying to "fingerprint" SQL on its way into the rdbms for a benchmarking process (so I can tie the resource allocation back to the process more precisely). To do this, I'm essentially... (4 Replies)
Discussion started by: toeharp
4 Replies

4. Shell Programming and Scripting

Problem with using a sed to add escape character \ before $ and ' symbols

Hi all, I've got a problem with sed. Want to use it to add escape character \ before $ and ' symbols so condition='1'$some will become condition=\'1\'\$some echo "condition='1'$some" | sed 's/\($\)/\\\1/g' is not working properly. Can somebody help me with this please? Regards,... (7 Replies)
Discussion started by: johny_be_good
7 Replies

5. Shell Programming and Scripting

awk escape character

ll|awk '{print "INSERT INTO SCHEMA.TABLE_NAME VALUES (`"$9 "`,"$5");" }' INSERT INTO SCHEMA.TABLE_NAME VALUES (``,); INSERT INTO SCHEMA.TABLE_NAME VALUES (`TABLE_PARTITION_Y2010M03D06.dmp`,7923328); INSERT INTO SCHEMA.TABLE_NAME VALUES (`TABLE_PARTITION_Y2010M03D06.log`,1389); But I want ' in... (2 Replies)
Discussion started by: faruque.ahmed
2 Replies

6. Shell Programming and Scripting

perl how to escape (|) character

my @array; my $sepa = "|"; print $sepa; open FH, "<100_20091023_2.txt"; while(<FH>){ push @array, split(/\$sepa/, $_); print "@array\n\n"; } I am not able split the line which have | separated (1 Reply)
Discussion started by: pritish.sas
1 Replies

7. Shell Programming and Scripting

Escape character - sed

Hi All, How do i write in sed for the 6th and 7th field of etc/passwd file as it involves "/" character? Does mine below is correct? It's incomplete script as i need help with syntax as i always getting may errors :( Example of etc/passwd file: blah:x:1055:600:blah... (6 Replies)
Discussion started by: c00kie88
6 Replies

8. Shell Programming and Scripting

Escape character

Hi , I want to change space to ' in my script. I tried doing this, sed 's/ /\'/g' filename but i could not get it. can some one help me please. Thanks, Deepak (4 Replies)
Discussion started by: deepakpv
4 Replies

9. Shell Programming and Scripting

Escape character in vi?

I want to replace a string which contains "/" in vi but what is the escape character for forward slash? e.g. I have a text file with the contents below and I want to replace "/Top/Sub/Sub1" with "ABC". /Top/Sub/Sub1 The replace command I am using is ... (4 Replies)
Discussion started by: stevefox
4 Replies

10. UNIX for Dummies Questions & Answers

possible to escape the \ character in sed?

is it possible to escape the \ character in sed? right now I'm trying to replace all occurances of \ with \\ sed \"s|test|test_replacement|g\" file1 > output; #this works fine sed \"s|\\|\\\|g\" file1 > output; #this generates the following error: sed: -e expression #1, char 17:... (1 Reply)
Discussion started by: gammaman
1 Replies
Login or Register to Ask a Question

LEARN ABOUT X11R4

escape

escape(1)							Mail Avenger 0.8.3							 escape(1)

NAME

       escape - escape shell special characters in a string

SYNOPSIS

       escape string

DESCRIPTION

       escape prepends a "" character to all shell special characters in string, making it safe to compose a shell command with the result.

EXAMPLES

       The following is a contrived example showing how one can unintentionally end up executing the contents of a string:

	   $ var='; echo gotcha!'
	   $ eval echo hi $var
	   hi
	   gotcha!
	   $

       Using escape, one can avoid executing the contents of $var:

	   $ eval echo hi `escape "$var"`
	   hi ; echo gotcha!
	   $

       A less contrived example is passing arguments to Mail Avenger bodytest commands containing possibly unsafe environment variables.  For
       example, you might write a hypothetical reject_bcc script to reject mail not explicitly addressed to the recipient:

	   #!/bin/sh
	   formail -x to -x cc -x resent-to -x resent-cc 
	       | fgrep "$1" > /dev/null 
		   && exit 0
	   echo "<$1>.. address does not accept blind carbon copies"
	   exit 100

       To invoke this script, passing it the recipient address as an argument, you would need to put the following in your Mail Avenger rcpt
       script:

	   bodytest reject_bcc `escape "$RECIPIENT"`

SEE ALSO

       avenger(1),

       The Mail Avenger home page: <http://www.mailavenger.org/>.

BUGS

       escape is designed for the Bourne shell, which is what Mail Avenger scripts use.  escape might or might not work with other shells.

AUTHOR

       David Mazieres

Mail Avenger 0.8.3						    2012-04-05								 escape(1)