UNIX for Dummies Questions & Answers

Hi,

this is my test file :

DELETE FROM TABLE
WHERE ID_INTERNAL = :TABLE.ID-INTERNAL, ID-INTERNAL-CRAZY
ID-INTERNAL-OPEN
ID-INTERNAL

/ID-INTERNAL/


I want all occurences of ID-INTERNAL replaced with a one, if ID-INTERNAL has and dash afer it , dont replace it example: ID-INTERNAL-CRAZY,

I'm using an awk script at the moment, but I'm having syntax errors,
especially with the system sed line ,any ideas ?

BEGIN{}
/ID-INTERNAL[^-]/ \
{
system( "sed s/" ID-INTERNAL "/" 1 "/" $file > $file.out)
}
END{}

gsub("ID-INTERNAL[^-]", "1")

my operating doesnt recognize "gsub"

It say syntax error I have the following:

BEGIN{}
/ID-INTERNAL[^-]/ \
{
gsub("ID-INTERNAL[^-]", "1")
}
END{}

what OS are you on?

and this?
gsub("ID-INTERNAL[^-]", "1", $0)

SunOs 5.9

when I add your latest change I have a syntax error.

this is what i have :

BEGIN{}
/ID-INTERNAL[^-]/ \
{
gsub("ID-INTERNAL[^-]", "1",$0)
}
END{}

works fine for me - no syntax errors.
make sure you don't have any control chars in your awk file.

Try nawk or gawk instead of awk. My SunOS system has an old version of awk.