Claude,
A. When you scan the table, call a function to perform number 2 with each field of your array. That should execute faster than scanning the table for each field.
B.
DO WHILE OCCURS(SPACE(2), lcString)
lcString = STRTRAN(lcString, SPACE(2), SPACE(1), 1)
ENDDO
C. It should unless the memo field exceeds the length that your version of VFP can handle as a string.
HTH,
>I need to remove unprintable characters from existing tables. My approch is to
>
>1. use AFIELDS function to find character and memo fields in a table
>2. For character field SCAN the table for each character field
> a. use CHRTRAN functuin to eliminate unprintable characters
> b. find lenght of new and old strings
> i. if lengths are diffrent replace old value with new one
>
>My Questions
>
>A. Is there a more efficent method of doining this?
>B. How can I remove multiple spaces so that there is only 1 space between text?
>C. Will this work for memo fields?
>
>Eventual goal is to a form where user picks the table to be fixed so that paths will be set. For testing I am writing this as a program.
Jim