Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to quickly look at Memo files, converting table to a
Message
From
16/01/2013 16:28:06
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01563035
Message ID:
01563036
Views:
104
This message has been marked as the solution to the initial question of the thread.
>Hi Gang!
>
>I have a table with some memo fields in it (along with some Character fields).
>
>I wanted to copy the data out quickly to a Text File.
>
>I tried
>
>COPY TO C:\TOMMY.TXT TYPE CSV
>
>but this only copied out the Character fields.
>
>How do I get the Memo fields out for analysis?
>
>Thanks!

Try to list the fields, and use a function, for instance padr(yourmemo,250), for the memo field. Or you can List them
List off field1,field2,padr(fieldmemo,250) to file somefile.txt noconsole
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform