Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create text file with field name + memo file
Message
From
26/07/2012 05:37:04
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01549228
Message ID:
01549307
Views:
49
>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform