Copying memo data into regular field?

[Boaz Bezborodko]

> Date: Fri, 27 Mar 2015 20:09:05 -0400
> From: "Stanley - stanlyn.com"<stanley at stanlyn.com>
> To:<filepro-list at lists.celestial.com>
> Subject: Copying memo data into regular field?
> Message-ID:
> 	<!&!AAAAAAAAAAAYAAAAAAAAAPR6Tw5LnS5CoVg+IvMfAXDCgAAAEAAAAFZeCsqAlCRAoeJqW1juytgBAAAAAA==@stanlyn.com>
> 	
> Content-Type: text/plain; charset="us-ascii"
>
> 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

I'm assuming that you are planning a one time conversion to some other 
format for you memo storage.  If so then why not output orprint each 
record to a separate file and name that file with some kind of reference 
key that links to the Filepro record?  You can then work with that 
output (or files) with some other program to fix/massage/re-import the 
data to the format you want.



---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com