Memo Fields and Export Issues

Stanley - stanlyn.com stanley at stanlyn.com
Mon Mar 23 18:07:32 PDT 2015


Hi,

I'm trying to export data from a filepro memo field in 254 character chunks.

1st problem was embedded carriage returns and line feeds inside the memo
field causing the export command to close the field assignments prematurely.
I removed them and now it properly processes all the chunks except the last
one.  I suspect a carriage return as the last character is causing the
problem.  I suspect that because the memo field on the entry screen shows an
ending/closing CR character as the last character. 

I'm attempting to trim the memo value by using: 	(212 is memo table
field)
mm(16,memo)=212 ; aa=""{mm{""

1. Will that perform a trim on both sides of mm, effectively all-trimming
it?
2. Would it remove or include the trailing spaces and/or cr/lf non-printable
characters?

3. In code what is best way to replace all cr, lf, and/or crlf that the memo
contains with a printable string such as "CRLF", so later in a post process
I can search on CRLF and substitute back to retain original format?  Some
code would be very helpful.

4. Is there any other issues with exporting memo fields that I need to know
about?

Using SCO 5 and filepro processing 5.0.14R4

Thanks,
Stanley Barnett







More information about the Filepro-list mailing list