RE: editing a csv file

A valid double quote is either preceded or followed by a comma.


-----Original Message-----
From: Quazy [mailto:quazy@SoftHome.net]
Sent: Monday, March 06, 2000 12:34 PM
To: rpg400-l@midrange.com
Subject: editing a csv file


I have a csv file, that has quotes" around  character fields, and nothing
around numeric fields.  

I need to look at all the character fields and make shure that they only
have one set of quotes in it, or the program that uses it will blow up.  

example.  

This one is ok 
10008,"DE LA BARRE, CRAIG","3120 OGORMAN","AZTEC","AZ","57105",,,,"DECRAIG"


This one is bad the "A"  has quotes but is inside of another field
10049,"GOHL, DONALD","1520 "A" RIVERDALE RD","DE
SMET","MN","57105",,,1833770


Any suggestions on what would be the best way to approach this?


Thanks 
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---