Search Results

u can.. but bit messy though


awk '{v=substr($0,45,22);sub(/[ ]+/," ",v);print substr($0,0,44) v substr($0,68)}' filename

if your lookup file is delimited, then you need to mention the FieldSeparator (FS) i.e. FS="|" in the BEGIN block before the while loop begins and then reassign it to FS = " " after the while loop...

I see. Quick fix in the UNIX tradition:
sed 's/\(.\{16\}\)...../\1_____/' inputfile |
awk 'NR==FNR{A[$1]=$2;next}{sub(/_____/,A[$(NF-2)])}1' lookupfile -

The first sed statement converts the...

You could use awk:

awk -F\| 'NR == FNR {
_[FNR] = $0; next
}
{ $4 = _[FNR] }
1' OFS=\| fileB fileA