testfile.csv
0","1125209",,"689202CBx18888",,"49",,,"NONMC",,,,,"01112010",,,,,,,"MTM-
"1","",,"689202ABx19005",,"49",,,"NONMC",,,,,"01072010",,,,,,,"MTM-
[]testfile.csv looks like above format
[]if the second column is null then get 23rd column and store in a different varible .. add all the 23rd columns if 2nd column is null .
[*]cut the entire line if second column is null and store in another file
[/list]
All the above condition should be checked for the entire file
Please help me ..
if I use below code
cat testfile | cut -d "," -f 2 > id
then all the id including "" stored in a file