Linux

If your input and desired output is exactly as shown above, then use :

Code:

 
awk  '/^GRANT/ && /DIM_/ {sub(/VW_\./,"");print} /^GRANT/ && /MBR_PRI|REF|SRVC/{sub(/_\.P/,"_P");print} !/^GRANT/'  filename > new_file

In case you need only the "GRANT" lines in the new file, try this:

Code:

 
awk  '/^GRANT/ && /DIM_/ {sub(/VW_\./,"");print} /^GRANT/ && /MBR_PRI|REF|SRVC/{sub(/_\.P/,"_P");print}'  filename > new_file

Rubin ,
The sql file that I provided here is just one of the many sql files that I have related to schema OOPSD002. Your solution will solve only one file but not the others. Ok , Here the general way any sql file is generated in our environment
<Schema_Name>.<Table_Name>.<Date>.sql

Can we make it dynamic , thats what I was talking to Franklin too .

I appreciate all of you guys who are trying to help me here .

Daya

Ok, what you want is to remove "VW_." in the first section of the GRANT lines and the dot after "VW_" in the other sections of the GRANT lines, right?

Code:

awk '
/^GRANT/ && /DIM_PROVIDER/{sub($0,"VW_.","")}
/^GRANT/ && /VW_.PROVIDER/{sub($0,"VW_.","VW_")}1
' file > outfile

With the given information in this thread you should be able now to find out how to use your variables in the awk command.

Regards

Thanks a lot Franklin , With few modifications to the code . its working all right now .

Appreciate your time and effort !!!

Daya

No problem, you're welcome!