string replacement in a memo field

[youwannawhat]

I have a user that has spelled a word incorrectly within a memo field, 2874 times. The word misspelled is contained within an otherwise correct entry.

I am able to retrieve the records with the misspelling by using STRTRAN, but I'm unable to specifically replace(correct) the errant word within the string.

The word is not always in the same position.

Thanks in advance for any help.

 

[Mike Gagnon]

The ATC function can help you find the position of the first character of the word you are looking for.
STORE 'Now ist the time to program in FoxPro ... ' TO cString
lnReturn= ATC('ist',cString)
lreturn = 5
And combine this "lnReturn" value with the STUFF() function to replace to correct value.

 

[DSummZZZ]

REPLACE MemoField WITH ;
STRTRAN(MemoField, "bad_word", "good_word&quot

will also work.

Dave S.