>My first attempt to edit a memo field. The memo field in table frx1, column expr, and contains:
>
>Alias = "qmf_temp"
>CursorSource = ..\tempdbfs\bg\qmf_temp.dbf
>Name = "Cursor1"
>
>
>Want to change the \bg\ to \xx\. How can I accomplish this?
>
How about:
REPLACE memofield WITH STRTRAN(memofield,"\bg\","\xx\")Think of a memo field as a big string in a table, with some built-in parsing that allows you to examine it line-by-line easily.
Processing a memo broken up into lines is simplified by some memo-specific functions; ALINES() can extract a memo into a 1 dimensional array of strings, you can use the MLINE() and MEMLINES() functions to spin through the memo line-by-line. ATLINE() and ATCLINE() will return memo line references for substring searches similar to AT() and ATC.