[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