Shell Programming and Scripting

Hello everyone !

Please have a minute and see if you know how to script this

I have a file like this:


"create table ....
...
create index n112 on ...
...
create table ...
....
create index n113 on...

...
create table ...
create index n112 on ...! duplicate
...

and so on ...

Can one make a script to find the duplicate index names and automatically rename them like n112kk0, n112kk1, n112kk2 ...etc ?

Thank you very much !

Code:

nawk '/^create index/ {if ($3 in dup)$3=$3 "kk" ++dup[$3];else dup[$3]}1' myFile