Re: editing a csv file

[Tom.Clements@xxxxxxxxxxxxxxx]

If all records are of same format - ie same number of numeric and character
fields - you should be able to scan for the " and count them, if the number
is more than the correct number, you have an error.

if you need to find the specific field:
(assumes first field is always numeric)
-->scan for comma
|    if next character is quote
|         scan for quote
|         if next character is not comma
|              you hit the error (or you're in the neighborhood at least)
 -loop

in other words, (comma quote) designates the proper beginning of a
character field and (quote comma) designates the proper end of the field.

(uh ... at least I think .... :-})


Tom Clements
Help/Systems Inc.
612-563-2780


                                                                                
                                    
                    "Quazy"                                                     
                                    
                    <quazy@SoftHome.n        To:     <rpg400-l@midrange.com>    
                                    
                    et>                      cc:                                
                                    
                    Sent by:                 Subject:     editing a csv file    
                                    
                    owner-rpg400-l@mi                                           
                                    
                    drange.com                                                  
                                    
                                                                                
                                    
                                                                                
                                    
                    03/06/00 02:33 PM                                           
                                    
                    Please respond to                                           
                                    
                    RPG400-L                                                    
                                    
                                                                                
                                    
                                                                                
                                    





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
+---