Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting foreign accents
Message
General information
Forum:
Visual FoxPro
Category:
Visual FoxExpress
Miscellaneous
Thread ID:
01648083
Message ID:
01648186
Views:
32
>i reproduce your "desirata" in the code below.
>when browsing the globalinx cursor you can see the first field (addfield) is accentued and the converted field (unaccentued).
>the conversion is made by a cursor scan
>in the first field you can put your "Paris la défense" or any accentued string.
>
>create cursor globalinx (addfield  c(150),unaccentued c(150))
>insert into globalinx values("Tellus donec pulvîar fancibüs à classé pésuéré arcu mattis, aliquét alèquam habitant juséo convallis tùrpus néc,","")
>insert into globalinx values("adipiscing enim !","")
>insert into globalinx values("énis nostra fuscé. Fringlilia vestibulum sed famès nostré morbi mattis ut, cubliâ classé curae metus conubia","") 
>insert into globalinx values("cél litoré, primis donéc dictum aliquet pulvîar et orci interdum.","")
>SELECT globalinx
>SCAN
>repl unaccentued with CHRTRAN(addfield, "ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ","AAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy")
>endscan
>brow
>
I am getting very confused my dbf file consists of about 1000 records and 20 fields of which 10 could have accents - I dont know what the accents are I just need to remove all accents from all of the 10 fields for all of the 1000 records - I dont understand your code - Is ther any other way you can explain i to me?

Thanks
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform