CSV files

[cback]

Hi

Another query ... I have a csv file with names and addresses, eg:
FRED,SMITH,128 NEW DRIVE,LONDON
but sometimes I get a record:
FRED,SMITH,"128 NEW DRIVE,HOLBORN", LONDON
where 128 NEW DRIVE,HOLBORN is the third field

Is there any easy way to code this in awk, perhaps with pattern matching for "*,*" or something?

Thanks

Chris

 

[vgersh99]

not easily, but......

comp.lang.awk had a long-running thread on this subject.

here's the link:

http://groups.google.com/groups?dq=&hl=en&lr=&safe=off&th=d36a298d43899790

vlad

 

[cback]

Brilliant - thanks, although it'll take a while to digest!