Shell Programming and Scripting

Hi,

I'm having a bit of trouble replacing sed's delimiter from a slash to a pipe.

This works...

Code:

sed '/INSERT INTO/s/\${TD_LOAD_DB}/NUC_PL_LOAD/g' sql_file.sql

But this doesn't

Code:

sed "|INSERT INTO|s|\${TD_LOAD_DB}|NUC_PL_LOAD|g" sql_file.sql

Although if i remove the INSERT INTO pattern, the delimiter works...

Code:

sed 's|\${TD_LOAD_DB}|NUC_PL_LOAD|g' sql_file.sql

Any ideas?

When using a character other than slash character ("/") as the delimiter in a context address, the first delimiter must be preceded by a backslash character ("\"), so try:

Code:

sed "\|INSERT INTO|s|\${TD_LOAD_DB}|NUC_PL_LOAD|g" sql_file.sql

Since there is no / in "INSERT INTO", why not use the default delimiter? (Note that the delimiter used for the context address and the delimiter used in the substitute command do not have to be the same character.)

Assuming that you're trying to search for the string specified by the variable TD_LOAD_DB, why do you have the backslash before the dollar sign?

Thanks Don, that's exactly what I needed.

The final version of this will use a variable which all contain backslashes. Also I backslashed the dollar as that is what I am searching for

Thanks for the help.