Copying memo data into regular field?

[Stanley - stanlyn.com]

Hi Ken,

>> Define "doesn't work".
Sure it does, but where does that play role here?  I can create a little output with 300=mid(212,"1","999") as its only line and run it.  Field 300 now contains what looks like 16 asterisks, therefore I'm saying it doesn't work.  I'm obviously missing something here...

>> Check the WORDWRAP() function, so that you don't have to worry about splitting the memo field mid-word.
I looked it up and from the help, I don't see (probably due to the lack of help) how this would help other that sanitizing the data.  Anyway, that is not an option for me as it is from v5.6.

>> 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 
Well, then I surely missing something here.  In my attempt to get this working, I created a screen that contains 2 long fields.  The 1st was 999 in length and the other was 518.  That fills up the screen.  I was hoping that when copying data to the first field that it would flow into the 2nd if it was longer than 999.  I'm copying text from notepad file that contains chr(9,10, & 13's).  When pasting a chunk, it wrote over itself and only on the 1st line (not field), 1st 80 characters, and it done it over and over until it completed.  I am using anzio for the paste operation.  Therefore the 999 char field only contains 80 characters (1 line).   If I reformat the test in notepad first by remove all the special chars, then it pastes in ok.  So how do you get the data into it especially if it contains those special chars?      

Thanks,
Stanley





-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
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