Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to quickly look at Memo files, converting table to a
Message
 
To
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:
01563039
Views:
50
>>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
BRILLIANT !!! (now all I need is to get the comma's in between the field output)....

Thanks!
Tommy Tillman A+ NetWork+ MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform