Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table with Memo field Export to txt file ?
Message
 
To
28/10/2002 09:58:39
Agnes Cheng
DynamicTech Consultants Ltd.
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00716035
Message ID:
00716068
Views:
15
Memo field contents may be very long and may contain chr(13) and chr(10) indicating line end. So the solution depends on how you need to handle these line breaks and long content in the particular record and on how they need to be inserted into text file. Otherwise something like this:

use (yourtable)
lnfp=fcreate("outfile.txt")
scan
fputs(lnfp,alltr(memofield))
endscan
=fclose(lnfp)

>I got a table which got one memo field only.
>I will generate 30-50 records each time and then export them into *.txt format.
>My txt file format must be 1ine feed.
>It means. 1 record pre 1 line .
>How can i do that ???
>
>Thanks in advance.
>From Agnes
Previous
Reply
Map
View

Click here to load this message in the networking platform