Is there a tool to replace these kind of characters
ä with a
ü with u
Ä with A
é with e
lots of possibilities, i can't find a way to do this.
Hi Daniel thnx for your reply
i need to convert a table with Patients (50.000) for a software migration
it is not allowed to deliver fields with diacritic characters, so the name, address, city etc. fields cannot have characters like ä and ü etc.
the list of characters can be big so i was hoping for a tool which can do the job for me
Try this in a formula:
DecomposeUnicodeForMatch([string])
is this better?
The potential problem of DecomposeUnicodeForMatch is that it also converts all characters to lower case and converts chacters like ¼ to 1/4 which may or may not be what you want. That function was written with the help of the Unicode spec, and its not too hard to roll your own with the same spec.
Attached is a module that downloads the raw unicode spec and takes some wholesale assumptions about what you might want and don't want and in the end uses a Find/Replace tool to actually change all the characters.
Hi,
Having this kind of issues very often with spanish, I created a macro to Find/Replace characters.
In this case, just to convert from unicode to ascii, but if you see the macro, there is a text input to make your own "dictionary" of replacements.
Hope this helps.
If you're just doing this for a small set of characters, you can easily accomplish via the REPLACE function. As shown below.
ReplaceChar([Field], 'ä', 'a')
Otherwise a more elegant solution would probably be via a REGEX expression or something.
Much better
We were having the problem for the report as well.
I did a macro to solve the problem.
Its a combination of Ned and aguisande solutions, if it can help someone.
