I want to read 9th column of text file with '~' delimiter and need to retrieve data from for the corresponding 11th column which resides in a table. that data i need to replace in 11th column of the file which is having NULL values currently.
How to achieve this in unix.
col1~col2~col3~col4~col5~col6~col7~col8~col9~col10~col11~col12~col13
data1~data2~data3~data4~data5~data6~data7~data8~data9~data10~~data12~data13
in the data data11 is null . so i want to take the corresponding value for data9 and replace the data11.
Thanks