Memo Fields and Export Issues

[Stanley - stanlyn.com]

Hi Ken,

And what is xlate?  Part of filepro?  3rd party?  

How would it be implemented as part of an export routine?

Are these issues related only to memo fields?

Thanks,
Stanley




-----Original Message-----
From: Ken Cole [mailto:ken.m.cole at gmail.com] 
Sent: Monday, March 23, 2015 9:42 PM
To: Stanley - stanlyn.com
Subject: Re: Memo Fields and Export Issues

Stanley,

That will trim leading and trailing spaces but not any other, even "non-printable", characters as they may be non-printable but they are not a space.

You will need xlate or similar to remove any other extraneous characters not required.

Ken

On Tue, Mar 24, 2015 at 12:07 PM, Stanley - stanlyn.com <stanley at stanlyn.com> wrote:
> 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
>
>
>
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes 
> http://mailman.celestial.com/mailman/listinfo/filepro-list