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