Convert umlaut to unicode

[pietschker]

All,

I could not find a solution to this problem in the FAQ, Forum Search or FM 7 Help.

I need to convert umlaut and accented characters to the ASCII unicode representation, for example a-umlaut (ä) should become u00e4

Is there a calculation/function to do this? (I am aware that I could create a custom function, but cueerntly I don't want to enter into that effort.)

Related q. Is there a way to get the ASCII number of a character?

[Nissim]

Hi,

You can create a custom function that converts character to ascii code something like

AsciiToNum("A") = 65

AsciiToNum("a") = 97

you can get the ascii codes here (found by google search).

parse the file for getting two columns only (num,text) and make your function...

[Nissim]

Hi,

I think that this is the function you searched .

Take a look at this link