Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting foreign accents
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxExpress
Divers
Thread ID:
01648083
Message ID:
01648179
Vues:
35
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform