Search Results

I assume that you already know that the script I gave you before cannot possibly work when there are no longer any header lines in your input files and all of the field separators are completely...

You could try something like:
awk -F '[ |]*' '
NR < 3 {print
next
}
!(($2 FS $5) in b) {
b[$2 FS $5] = sprintf("| %s | %s | %s | %s | ", $2, $3, $4, $5)
e[$2 FS $5] = sprintf(" | %s | %s...

There is a replace function that can do just that:

SQL> update tablename set name = replace( name, 'string', 'sequence' ) where id > 5;

(assuming Oracle or mySQL)