>I have a requirement to export large database to a "|" delimited database. There are 13 fields required 2 of which are memo fields containing large quantities of text. The problem we are having is extracting this text, in the memo fields, for use in the ascii text file. We have tried to append the memo field to a file and then extract this using the clipboard commands of the win API but this does not seem to work.
>Has anybody got any suggestions as to how we might copy these fields into the delimitted ascii file.
>
>Thanks for any assitance
>
>Brendan
Breandan,
Export with lowlevel :
function dbfexport
lparameters cTableName, cFields, cWhere, cExportFileName
select &cFields from (cTableName) where &cWhere into cursor tcExport
handle=fcreate(cExportFileName)
#define maxlen 65535
scan
for ix=1 to fcount()
=fwrite(handle,Convert2Char(eval(field(ix)))+"|",MAXLEN)
endfor
=fputs(handle,"")
endscan
=fclose(handle)
use in "tcExport"
Cetin