Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create text file with field name + memo file
Message
De
26/07/2012 05:37:04
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01549228
Message ID:
01549307
Vues:
50
>>I've been away form VFP for a bit, so I'm a bit rusty, and I can't construct the following.
>>
>>A free table has a customer ID and a memo field with various comments.
>>
>>I want to "export" this to a Text file.
>>
>>IF I use COPY TO... type csv, the memo fields do not show. Do have to apply a function to get them into the csv file?
>>
>>IF I create a report, it shown the memo field when displayed or printed, but when I try to create a text version of the report, the memo field comes across as garbage, not ascii.
>>
>>Other options, or gotchas that I may have missed?
>>
>>Thanks.
>
>If the table is not too big, you can scan it and manually output row by row using low-level file operations or strtofile.

The trouble would be in the details - delimiters and separators, in this case. If you output memos to a text file, there is no guarantee that your text within text (memo contents inside text file) would not contain the separators and delimiters used outside of it. While this may be ignored for an output for human use, i.e. a report, the next thing that follows is that someone will try to import from this text file, and trouble will begin.

Another option is to export as XML paired with an XSL for formatting and then output it as html. Which I've seen done, but never did myself.

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