Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CSV files with comma and quotes
Message
De
12/11/2018 17:55:26
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
12/11/2018 16:41:06
Thomas Ganss (En ligne)
Main Trend
Frankfurt, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01663238
Message ID:
01663289
Vues:
47
>Such things crop up with one forgotten kink at moments where you are already stressed.
>
>My first action (after overcoming the programmers itch to fix myself) is to contact originator of the file and change the structure of the file if possible, bracketing ALL char fields with almost-never-used character if possible or at least get consistent handling of char fields.
>Most of the time that is enough for handling with /with character clauses of append from type delimited.

I dunno where you live or what you're on, but I'd like some of that too.

Contacting the author is practically never an option. Most of the time I don't even know where the files are coming from, or when I know, it's a legacy app (usually written in Clarion) which has the option to export everything into Excel. The worst part is that they try to be helpful by omitting the redundant columns, but often omit different columns each time.

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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform