Alaska Software Inc. - Importing Memos
Username: Password:
AuthorTopic: Importing Memos
Garry Allen Importing Memos
on Wed, 13 Dec 2006 16:06:59 -0500
My program has to import some data from an old Clipper S87 program. The
import works fine except that allof the CR/LF's in the memo's now appear as
graphics (hex 8D 0A). The 'new' files are Fox CDX. 
Could I have prevented this on import or do I have to do a search/replace on
the imported memos?
Richard DalzellRe: Importing Memos
on Wed, 13 Dec 2006 18:29:11 -0600
Gary,

Here is what I used:

SELECT 0
USE DataBase
GO TOP
DO WHILE !EOF()
  REPLACE MemoField WITH MEMOTRAN(MemoField, " ", " ")
  SKIP
ENDDO

You might also look into HardCr()

Rick
Garry Allen Re: Importing Memos
on Thu, 14 Dec 2006 03:14:14 -0500
Thank you -that WAS easy! I had totally forgotten about memotran()
Garry

Richard Dalzell wrote:

> Gary,
> 
> Here is what I used:
> 
> SELECT 0
> USE DataBase
> GO TOP
> DO WHILE !EOF()
>   REPLACE MemoField WITH MEMOTRAN(MemoField, " ", " ")
>   SKIP
> ENDDO
> 
> You might also look into HardCr()
> 
> Rick