Processing Memo Data (FoxPro 2.6) 1

[porto99]

Its about 10 years since I did anything with FoxPro 2.6, but I would like to be able to process some Memo fields in an old database.
Just want to remove non-printing characters.

Can someone show me a snip-it of code to get the charaters in a Memo field and run throught the whole table replacing 'bad' characters with spaces.

Many thanks,

Porto

 

[DSummZZZ]

Try this:

REPLACE ALL table.memofield WITH ;
Chrtran(table.memofield, Chr(1) + Chr(2) + ..., '  ')

Substitute the CHR()'s for whatever characters you want to replace, and use the same number of spaces in the third parameter as you have for CHR()'s in the second parameter.

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm