Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cleaning data before append
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Cleaning data before append
Divers
Thread ID:
00754250
Message ID:
00754250
Vues:
39
Hello,
I've got a 30+mb text file that I need to put into a cursor. I've got the structure all figured out. The problem: The data is comma delimited, with double-quotes as the text delimiter. However, some of the fields contain the double quote character. My first thought was to just strtran() the whole thing and get rid of the quotes. This worked pretty good (took a little time), but then I discovered that some of the fields also contained a comma. I rolled my own parser and ran the file against it, but it took forever! ( well, actually I halted the process after about 15 min and it was something like 0.4% complete ). Anybody got any ideas. What I need to do is basically remove every double quote that is not immediately preceded, or followed, by a comma. Or am I just missing somehting simple somewhere ( I hope this is the case ). Thanks a lot,

jfh
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform