Hi Richard,

It can be done with name expression and EVAL() function which is mach faster than macro substitutuon.

...
  REPLACE (FIELD(I)) WITH CleanMemo(EVAL(Field(I)))

>I have a lookup table with 27 records and 71 fields per record.
>65 of those fields are MEMO fields containing static text.
>I need to update each memo field to remove junk (carridge returns and line feeds) from the end of each memo.
>
>Is there a way I can access the content of the memo fields by number instead of name?
>I'd like to do something like....
>
>

>SCAN
> FOR I = 6 TO 71
>  REPLACE FIELD(I) WITH CleanMemo(Field(I))
> ENDFOR
>ENDSCAN
>

>
>So if Field(6) contains
>

>"Mary had a little lamb.$%$%"
>

>where $ represents CHR(10)
>and % represents CHR(13)
>
>CleanMemo(Field(6)) would return
>

>"Mary had a little lamb."
>

>
>All I can get so far if that Field(I) returns the field name, but I can't get the field contents.
>
>Rick