Exporting query wth memo field to type delimited file

[ryebread]

I am exporting a query that returns a memo field using...

COPY TO "C:\pdf\memodata.csv" TYPE delimited

into a comma delimited file.

Life is good.. untill i realized that the memo field was not exported.

Any help?

 

[FoxProProgrammer]

You might try converting the memo field to a text field before exporting it. How many characters are in the largest memo field? I wrote a program that converts a memo field to one or more text fields of width 254 characters. If you want to use it, I'll be glad to email it to you. Just post your email address.

dz

 

[ryebread]

my memo fields contain about 4 pages of text in each field. so the 254 char limit is a bummer.

I guess i can scan through the table and write each record to the text file by interating through each mline and adding it to the text file but use \n to represent the line breaks. was hoping there is an easier way.

I need to use these memo field text to import into a mysql db. So far the simplest way is to import with a delimited text file.


thanks for the help!

Ryan

 

[baltman]

Try:
repl all memofield with allt(memofield)
go top
copy MEMO memofield TO test.txt
for x = 2 to reccount()
go x
COPY MEMO memofield TO test.txt ADDITIVE
endfor

 

[FoxProProgrammer]

The amount of data that my program can handle is limited only by the number of fields it needs to create. It might not be useful in your application, but I used it to import a dbf into Access since the import function doesn't move memo fields. The program sets the memowidth to 254 characters, and creates a text field for each line in the memo field. I used 254 characters because that is the limit for a text field in FoxPro. If your memo field is 4000 characters (with no line breaks), the program would create 16 new text fields and copy the first line of the memo field to newfield1, the second line to newfield2, etc. Once you get the data into text fields and imported into the destination, you could concatenate the text fields into a single field on the new platform, obviously subject to the limitations of the new platform. If you think the program would help you, I'd be happy to give you a copy.

dz

 

[ryebread]

Thanks for all the help! This is how I resolved my export problem.

----- export.prg -----------------------------------------


fpath="C:\webpages\memofoxpro\momed\"
fname="export.txt"

SET DEFAULT TO &fpath

foofighter= Fcreate(fname)

USE memodatatmp
SCAN

&& write id and date
expstr='"'+ALLTRIM(id)+'"*'+'"'+date+'"*'
=FWRITE(foofighter,expstr)


&&write subject
expstr='"'+STRTRAN(STRTRAN(ALLTRIM(subject),'*',''),'~','')+'"*"'
=FWRITE(foofighter,expstr)

&&write body
cntr=MEMLINES(body)
FOR i=1 TO cntr

bodym=MLINE(body,i)
expstr=STRTRAN(STRTRAN(ALLTRIM(bodym),'*',''),'~','')
=Fputs(foofighter,expstr)

endfor

&&write filename
expstr='"*"'+ALLTRIM(filename)+'"~'
Fwrite(foofighter,expstr)


ENDSCAN

FCLOSE(foofighter)

 

[apffal]

How can I export a dbf table, with a large memo field, to a csv or text file ?
Thanks.

 

[rgbean]

apffal,
The best available technique for the exporting memo fields (at least that I've found) is the code in

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q241424

- "HOWTO: Export Memo Fields with Other Field Types to a Text File (Q241424)".

Rick