Copying memo data into regular field?

[Stanley - stanlyn.com]

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.

 

Or if something like this was available:  aa=text(212)

 

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.

 

How can this be done?

 

You ask why would anyone want to do this?  Because filepro memos are a
disaster.  at least that's my experience and I need to move away from them
while salvaging whatever data that hasn't been hosed.  Simply, I can't trust
it!

 

How would you do this?

 

Thanks,

Stanley

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20150327/439a340d/attachment.html>