Copying memo data into regular field?

[Richard Kreiss]

Top Post:

Ken, Stanley advised he had filePro 5.0.14 and if I am correct, wordwrap()
appeared with 5.6.

Richard

> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Kenneth
Brody
> Sent: Saturday, March 28, 2015 10:18 AM
> To: Stanley - stanlyn.com; filepro-list at lists.celestial.com
> Subject: Re: Copying memo data into regular field?
> 
> On 3/27/2015 8:09 PM, Stanley - stanlyn.com wrote:
> > Hi,
> >
> > I need to get memo data out and for now, I'll save it into standard
> > long fields, like (4) 999 character fields 300, 301, 302, 303.
> >
> > The memo field is # 212.
> >
> > I was hoping that this would work, but it won't.
> >
> > Then: 300=mid(212,"1","999") ; 301=mid(212,"1000","999") ;
> > 302=mid(212,"2001","999") and so on.
> 
> Define "doesn't work".
> 
> > Or if something like this was available:  aa=text(212)
> 
> Check the WORDWRAP() function, so that you don't have to worry about
> splitting the memo field mid-word.
> 
> > But first we must sanitize the data by removing all tabs, line feeds
> > and carriage returns, because a regular field cannot contain any of
those
> chars.
> 
> Sure they can.  It will look "funny" on the screen, and will probably mess
up any
> output, but there's nothing stopping "regular" fields from containing such
> characters.
> 
> Note, too, that WORDWRAP() will remove the hard returns if you ask it to.
> 
> [...]
> 
> --
> Kenneth Brody
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list