>Hi Colin
>what is 'i' replacing your addfield field in cursor or table globalinx?
>it must be mandatory a character string containing the accentued chars to replace with non accentued ones (as the syntax above).if no replacement made the chrtran returns original character expression.
>please correct your addfield if the case and retry .
>the example i gave works as well.
Sorry I am being so slow on this one - can you tell me where my code is incorrect
globalinx.i is the field in the table which has the town names with accents. in the file is the name Paris La Defense with an accent of the first e of Defense - the accnt doestnt get removed by the following code. I am trying to replace the accented names in field i with non accentuated oned
STORE globalinx.i TO addfield
m.mynewVar=CHRTRAN(addfield, "ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ","AAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy")
SELECT globalinx
replace i WITH addfield
This still doesn'r solve it
Thnaks for all your help
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing