Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I append from delimited file
Message
De
16/10/2003 19:10:42
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How do I append from delimited file
Divers
Thread ID:
00839564
Message ID:
00839564
Vues:
55
A file exported as comma-delimited from an accounting system should be imported in a VFP table. However, there are 4 weird symbols in the begining and in the end of every field in the file. When I append data - it creates empty records in the table. If I open the export file in NotePad and close it, the strange characters disappear. I can fix data in the export file by going through all data and saving only digits, alpha, and some other(.,"-). It take too much time. Also, I think there should be a smarter and easy way to resolve this problem.

TIA

Ed
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform