Copying memo data into regular field?

[Kenneth Brody]

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