Search Results

See the below code,
$cat infilevoucher DOB amount name type
====== ======= ======= ================== ===
37836452 1/13/1961 ...

Try...$ cat file1
John 1234 BASIC 26000
John 1234 ALLOWC 01550
John 1234 INCER 01700
John 1234 REL 20000
Debi 2345 BASIC 29000
Debi 2345 ...

Hi Vakharia, you're welcome. In regular awks, RS can only be one character. If more characters are used, the leftmost character gets used. GNU awk (gawk) allows RS to be a regular expression. Try:
...

Try:
sed 's/AM/\n&/g' file
or if you have GNU sed:
sed 's/AM/\n&/2g' file

try:
awk 'NR>1{print "AM"$0}' RS="AM" urfile

awk -F"[:,]" '
NR==FNR{a[$2]=$1;next;} # (1) It only builds array a for file2 (that's the first file in awk command) , NR==FNR is used to control it.
a[$3] # (2) then check if we have the same...

To thank in this forum is, click the Thanks Thumb.

a[$3] is used to build an array a in awk.

some updates base on pravin27's code, to fix the problem if there are different spaces or tabs before and after city and country name.

awk -F"[:,]" '
function s(a) {gsub(/^[\t ]*/,"",a);gsub(/[\t...

Try this,

awk -F"[:,]" 'NR==FNR{a[$2]=$1;next;} a[$3] { print $1,$2,$3,a[$3]}' file2 OFS="," file1