Is there a function or a way to parse a String to a Number?

[marcel_olmo]

Hello guys, I have a table like this :

And I would like to know if I can parse directly for example 'A.TOT' to an unique numeric field, and so on to the other fields.

Many thanks in advance!!!

[marcel_olmo]

The point is, it has to be unique numeric field for each kind of string field. Because after that I want to do an intervalmatch with another string table.

I know that you can't do an intervalmatch between strings, that's why I want an unique numeric field for each string.

Many thanks in advance.

[johnw]

Autonumber(Row_father)?

[marcel_olmo]

Thank you John for your answer.

I recently solved the original problem at this post, if you're interested :

http://community.qlik.com/forums/t/35991.aspx

In fact, I finally used autonumber function to create a numeric value associated to the alphanumeric rows.

What I wanted initially, is if for example I have a field with the value 'A.10', call some function to turn it to an unique id number. And if I find another row with the same value 'A.10' get the same id number.

Maybe some string to integer parser that matches non numbers to numbers, like ( A ->1, B->2, .... Z -> 30 ).

I did it with autonumber in the table I wanted to do an intervalmatch, and then applied to a base table using applymap.

You can see it easily in the example of the link.