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