UNIX for Dummies Questions & Answers

Yes Mr. Seaten.... thts what exactly "-e 's/ID-INTERNAL[^-]/1/g'" is for

this will replace all ID-Internal except if next followin character is other then '-'

Ok,


Take a look at the following sample file which I want to work on:
DELETE FROM TABLE
WHERE ID_INTERNAL = :TABLE.ID-INTERNAL, :ID-INTERNAL-CRAZY + :ID-INTERNAL
:ID-INTERNAL-OPEN
:ID-INTERNAL

with your command I get the following result which is very good, but it removes the comma at :TABLE.ID-INTERNAL, which is not allowed take a look at the output

DELETE FROM TBBETGRP
WHERE ID_INTERNAL = :TBBETGRP.1 :ID-INTERNAL-CRAZY +:1
:ID-INTERNAL-OPEN
:1


Notice the comma is gone, it wouldnt always be a comma it could be a bracket or plus sign ?

this should be take care for ,+ and bracket well...how to do it one shot of regular expression i am not aware...


sed -e 's/ID-INTERNAL /1 /g' -e 's/ID-INTERNAL,/1,/g' -e 's/ID-INTERNAL(/1(/g' -e 's/ID-INTERNAL+/1+/g' -e 's/ID-INTERNAL$/1/g' $filename

similarly you can add as many different characters you want to keep?

if anyone can help to know wht command to use in order to substitute
soemting like 'ID-INTERNAL[,+( ]' with '1[,+( ]' depending on which character was followed by ID-Internal same character need to be following 1.

rishi

Try...

Code:

$ cat <<EOF | sed -e 's/ID-INTERNAL$/1/g' -e 's/ID-INTERNAL\([^-]\)/1\1/g'
> DELETE FROM TABLE
> WHERE ID_INTERNAL = :TABLE.ID-INTERNAL, :ID-INTERNAL-CRAZY + :ID-INTERNAL
> :ID-INTERNAL-OPEN
> :ID-INTERNAL
> EOF
DELETE FROM TABLE
WHERE ID_INTERNAL = :TABLE.1, :ID-INTERNAL-CRAZY + :1
:ID-INTERNAL-OPEN
:1