Re: Comma seperated value file processing

[Chantelle Wall <cwall@MAIL.RATH.PEACHNET.EDU>]

An alternative way would be to read into one field and use the extract verb to
put the data into individual fields moving around the commas. Time consuming,
but if done properly, accurate.

ANDERSD2 wrote:

> Beware of fields holding text that contain commas as the unstring will not
> adjust for this contingency.  For example, the following line would mess up
> the UNSTRING command
>
> one,two,three,"four, and five",six
>
> good luck
>
> -----Original Message-----
> From: Weinstein, Bruce [mailto:bweinste@NRCAN.GC.CA]
> Sent: Monday, April 30, 2001 3:47 PM
> To: SQR-USERS@list.iex.net
> Subject: Comma seperated value file processing
>
> I have to read a comma seperated value file.  What would be the OPEN & READ
> commands required to achieve this?
>
> Thanks for your help?
>
>         .B
>
> ~~~~~~~~~~~~~~~~~
> Bruce Weinstein
> 613-995-2209
> bweinste@nrcan.gc.ca