How to use FS for mixed file?

Shell Programming and Scripting
1

Hi! All

I am just wondering solution to use FS if file fields are separated by whitespace (one or more spaces ), tab and comma, How to use FS ?

finally I want to print all columns as tab separated

look at my file here tagged

130, US  121337   30.530   -58.900 1941  1 25 19.50  4183107   17,60.0,(2),[00],19.900,(3),[00]
130, US  121337   30.530   -58.900 1941  1 25 19.50  4183107   17,65.0,(2),[00],19.900,(3),[00]
130, US  121337   30.530   -58.900 1941  1 25 19.50  4183107   17,70.0,(2),[00],19.800,(3),[00]
130, US  121337   30.530   -58.900 1941  1 25 19.50  4183107   17,75.0,(2),[00],19.700,(3),[00]
130, US  121337   30.530   -58.900 1941  1 25 19.50  4183107   17,80.0,(2),[00],19.600,(3),[00]
131, US  121337   30.570   -58.970 1941  1 25 19.00  4183108   25,0.0,(1),[00],20.300,(3),[00]
131, US  121337   30.570   -58.970 1941  1 25 19.00  4183108   25,5.0,(1),[00],20.300,(3),[00]
131, US  121337   30.570   -58.970 1941  1 25 19.00  4183108   25,10.0,(2),[00],20.400,(3),[00]
2 
[ \t]*,?[ \t]*
3

How do I use it ?

I want to print something like this

awk '{print $2,$6,$7,$13,$14}' OFS="\t" file

whether I have to use with BEGIN ?

4 
awk -F'[ \t]*,?[ \t]*' '{print $2,$6,$7,$13,$14}' OFS=\\t file
5

I got about 80% result but few are not printing properly

kindly go through attachment

6

That is an artifact of some columns being wider than others. -54.200 is one less than a tab, so a tab moves it just one space ahead. -119.075 is one longer, so gets bumped one tab stop further along. It's still text-tab-text-tab-text-tab, not text-space-space-space-space-space-text.