UNIX for Beginners Questions & Answers

a~b~c~d~12~r
a~b~c~d~12~r
a~b~c~d~12~r
a~b~c~d~12~r

a~b~c~d~12~r~~~~~~~
a~b~c~d~12~r~~~~~~~
a~b~c~d~12~r~~~~~~~
a~b~c~d~12~r~~~~~~~

awk -F"~" '{i=NF;while(i<14){val=val?val "~":"~";i++};print $0 val;val=""}'  Input_file

$ cat file
a~b~c~d~12~r
a~b~c~d~12~r
a~b~c~d~12~r
a~b~c~d~12~r

$ awk -F~ 'NF < 12 { $12 = FS } 1' OFS=~ file
a~b~c~d~12~r~~~~~~~
a~b~c~d~12~r~~~~~~~
a~b~c~d~12~r~~~~~~~
a~b~c~d~12~r~~~~~~~

awk -F"~" 'NF=12' OFS="~" file
a~b~c~d~12~r~~~~~~
a~b~c~d~12~r~~~~~~
a~b~c~d~12~r~~~~~~
a~b~c~d~12~r~~~~~~

#The below gets the no of record delimiter in the data file
head -1 datagen.txt | awk -F'~' '{ print NF-1 }' > nrd.dat
###############33

#!/bin/ksh
for i in `cat nrd.dat`; do
export df=`expr 10 - $i`
echo "$df"
export dlm='~'
echo "$dlm"
done
awk 'BEGIN { while (count++<14) string=string "~"; print string ;break}' > pt.dat