Richard,

a simple idea would be to use macrosubstitution like:

>SCAN
> FOR I = 6 TO 71
lcMacro =  [REPLACE ]+FIELD(I)+[ WITH CleanMemo(]+Field(I)+[)]
&lcMacro
> ENDFOR
>ENDSCAN

Agnes

>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