Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appendig csv file in cursor
Message
From
10/05/2018 10:34:12
 
 
To
10/05/2018 06:55:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Miscellaneous
Thread ID:
01659891
Message ID:
01659901
Views:
64
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform