I'm trying to convert a simple comma delimited text file to a database file(.dbf)(IV preferably). I can do this very easily in MS Excel but I don't believe I can automate Excel in UNIX with a shell.
thanks
K
I'm trying to convert a simple comma delimited string to a database file(.dbf)(IV preferably), and I want to do it in UNIX so I can automate the process. I can easily do it in MS Excel but I don't believe I can automate Excel in a UNIX env.
thanks
K
Here is a portion of the exact text file that I'm working with:
AST_L1A.002:2002141577,Aug-17-00-11:16:29,91.3174,71.9374,14.8706,-6.8062,14.7895,-6.2338,14.2312,-6.3565,14.3122,-6.9275,28,34,37,40,35,1226,01.02,01.02...
The file I'm working with looks like this,
a,b,c,d,e,f,g,h,i,
a,b,c,d,e,f,g,h,i,
and so on. The abc's are just representaions, in the file they are all different values. Each string ends with a comma and a return. I need to seperate the fields into something like this,
a
c,d
e,f
g,h
a
c,d...
I'm working with a text file that is composed of several hundred comma deliniated strings that I need to parse out and print back to a file. I'm new to AWK and need a little help on how to get started. I'm familiar with C.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.