Agnes,
Thank you!
It worked!

Rick

>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