Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting Memo fields to delimited text
Message
From
28/12/2001 12:22:22
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
28/12/2001 11:49:14
Bera Aksoy
Metro Truck Leasing, Inc.
Beltsville, Maryland, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00598836
Message ID:
00598859
Views:
16
>I am currently exporting my tables to delimited text files. I don't how to carry the text under the memo fields in the process. I would greatly appreciate if someone could tell me how to do it or point me to an appropriate source.
>
>Thank you.

Memo files are incompatible for text exporting. Depending on their nature you could use workarounds though :

1) If content is LTE 254 chars :
select ... left(myMemo,254) as myMemo from myTable into cursor ...
copy to ... type delimited

* If embedded linefeeds use chrtran(myMemo, chr(13)+chr(10), ' ')

2) Export lowlevel.
3) If receiver side could process it - why not :)
Export as normal + write out memos to separate external file(s).
-PKIds would be filenames if used multiple files
-If written out to one memo < g > file than before and after each memo write its PKID ( like [PKID=123]....[PKID=123] or XML style tags )

PS: VFP7 could output to XML or you could do it with ADO too but I think XML is not an option for you.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform