Hi All,

I am new to unix shell scripting, I need your help guys in coming up with some thing for the following scenario:

I have an .sql file which contains:

####This resides in .sql file ----------------------------------------------

INSERT INTO /*<base>*/ABC_BASE.tablename

SELECT
col1, col2

FROM
/*<acc>*/ABC_ACC.tablename2

WHERE
so_dt >= /*<from_date>*/'01-01-2006'
AND
so_dt < /*<to_date>*/'01-15-2006'

####This is the desired output--------------------------------------

INSERT INTO /*<baseDB>*/${base}.${xyz}${def}_tablename

SELECT
col1, col2

FROM
${acc}.ABC_ACC.tablename2

WHERE
so_dt >= /*<from_date>*/'${from_dt}'
AND
so_dt < /*<to_date>*/'${to_dt}'

The tags are commented, by using tags we have to match the pattern and replace as above.

This is the opposite of the regualr stuff

Thanks for you time guys... waiting for ur answers

You want to replace above with below or wice verca?

0 members found this post helpful.

I want replace above with below

1 members found this post helpful.

Welcome to LQ.

Sorry that I can't help w/ your Q; sorrier that you got prematurely bumped from the 0-reply list & its 3 days of auto-bumping.

Did you find a solution on your own?

It looks like you want to look into sed - it's quite an involved subject, but there are plenty of good tutorials on t' internet.

Frankly, for anything that fiddly, I'd use Perl. It's very good at that kind of text mangling.

I agree with chrism in that it's a "bit fiddly" because of the special characters, but since I'm not into perl and not great with AWK, I'd probably try to use sed; with some escapes of the special chars, it shouldn't be that hard.

PS - @ archtoad -- I just noticed the dates :/ wonder what happened..

FWIW, I made a text file named "weird" containing the string:

/*<acc>*/ABC_ACC.tablename2

Then ran a sed command on the file, to replace that string with the desired one: ${acc}.ABC_ACC.tablename2

like so:

shell$ sed -i 's%\/\*<acc>\*\/ABC_ACC.tablename2%${acc}.ABC_ACC.tablename2%' "weird"

and that worked fine.. So, using the /g suffix on the sed command would proceed through the whole file. And, using the same methodology, you can do the same sort of search+replace for the other selections you want to switch..

Sasha