Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CSV files with comma and quotes
Message
From
12/11/2018 17:55:26
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
12/11/2018 16:41:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01663238
Message ID:
01663289
Views:
46
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform