Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CSV with Memo fields
Message
De
17/02/2019 18:01:30
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Divers
Thread ID:
01666482
Message ID:
01666483
Vues:
60
>Hi everybody,
>
>I'm attempting to help someone in NY to extract their data from Exceed program into CSV file. The DBF have long Memo columns. I'm wondering what are my options to properly convert this info into CSV?

If you control the extraction, replace cr/lf in the memos with pipes or other otherwise unused character, then have whoever imports that convert back. Do something of the kind with commas in the memos (and other character fields, and also numerics with decimals if european format) too. Otherwise, tab delimited is better, at least you don't have to worry about the commas.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform