SED ERROR 1

[joeroe3380]

i have the sed statement to change
to_char(BASE_DT, 'YYDDD')to to_char(CYC_DT, 'YYDDD')BASE_DT.
The sed that i have is :
sed 's/to_char\(BASE_DT, \'YYDDD\'\)/to_char\(CYC_DT, \'YYDDD\'\) BASE_DT/g' outdat.sql > osql.sql

However this gives an error. Please advice on the right syntax.
Thanks a lot
roe

 

[PHV]

sed "s/to_char(BASE_DT, 'YYDDD')/to_char(CYC_DT, 'YYDDD') BASE_DT/g" outdat.sql > osql.sql


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244