Search Results

# expanded lines and fixed errors
awk '{ arr[NR]=$0;
if (index($0,"union all")>0)
{L=NR}
}
END {
gsub(/union all/, "", arr[L])
for(i=0; i<NR; i++)
...

Does Centos have the ex utility? If so, for the features I used in the ed script in post #3, ex will work the same way with the same options. On UNIX, Linux, and BSD systems, I usually use ed...

Hi antosr7,

This may be one of the methods:

grep "test3" <input_filename> | sed "s/ union all/;/"

where the test3 is the keyword to extract the line and the <filename> is where the three...

Another way:
ed -s infile <<-EOF
?union all?s//;/
w outfile
q
EOF
where infile and outfile, respective, are pathnames to your input and output files.

You can just use:
w
instead of:...

One way:

awk '{ arr[NR]=$0; index($0,"union all")>0 {L=NR} }
END { gsub(/union all/, "", arr{L})
for(i=0; i<NT; i++)
{print arr[i])
}' infile > outfile...