Search Results

awk -F"|" '
{ o[$2 FS $3]=1; p[$2 FS $3 FS $1]=1; }
END {
t="SCHEMA|TABLE|SELECT|INSERT|UPDATE|DELETE|REFERENCES"
print t; n=split(t, a, FS);
for (i in o) {
l="";
for...

Hello dineshaila,

Welcome to forums, please use code tags for codes/commands/Inputs which you are using into your posts as per forum rules. Coming onto your question, couldn't understand by which...

I'm not sure why you have a closing COLOR tag in your input file nor why it shouldn't be copied to your output file, but ignoring that, the following seems to do what you want:
awk '
/^dn:/...