[lug] awk question
dafr at peakpeak.com
dafr at peakpeak.com
Tue Jan 28 08:50:43 MST 2003
>
> Unfortunately not -- Yet more clarification that I didn't provide. ;)
>
> I _do_ need to deal with several different fields within the record, some of
> which are happily seperated by "," and others whose data is contained within
> "" where commas might/might not be present. This all _should_ of course be
> easy since we have a "global" standard and the variance should not be
> present... But you know how those work...
>
> Thanks for the suggestion, though.
> Jim
Alright, I have to admit that it took using Excel to come up with this one, but
how about importing the data into a spreadsheet, and then saving as a tab
delimited file? This would cause:
1,2,"3,4",5 ---> 1 2 "3,4" 5
Would that work for you? Failing that, would you be able to "massage" the file
in the same manner?
Again, just throwing out ideas here,
David
-------------------------------------------------------------
This message was sent from Peak to Peak Internet.
DSL - V.90 modems - Web Hosting and Business connectivity
Please visit! http://www.peakpeak.com
(888)-600-PEAK
-------------------------------------------------------------
More information about the LUG
mailing list