Search Results

Again, your input data and the sorted input data do not match. If you had sorted the input on the first four columns (assuming | is the field separator), SUB would follow MULT in your sorted when...

nawk '{
for(i=3;i<=4;i++)
if((n=split($i,a,"/"))==3)
$i=sprintf("%02d/%02d/%04d",a[1],a[2],a[3])
}1' FS=\| OFS=\| infile

awk 'END{print RS} /^[0-9]/{if(NR>1)print RS}1' ORS=

Try:
sed 's/$/~/' infile