Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Appendig csv file in cursor
Message
De
10/05/2018 10:34:12
 
 
À
10/05/2018 06:55:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Divers
Thread ID:
01659891
Message ID:
01659901
Vues:
62
>i have a csv file with accentued characters and i suppose its UTF-8 encoded.
>i create a cursor and append this csv file in it with this command:
>
>append from filename.csv type csv
>
>i have a problem wit accentued characters as : "vidéos" transformed in vfp as "vidéos"
>is there a clause i missed to have same fields? even adding codepage (as 1252) this dont solve."set nocptrans fieldname.." also dont solve the problem.

Yousfi

If the file has a BOM, you may try the CSVProcessor class at https://bitbucket.org/atlopes/csv. It should create the cursor and transform the data into ANSI.
----------------------------------
António Tavares Lopes
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform