topic Is there a function or a way to parse a String to a Number? in QlikView

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

marcel_olmo — Wed, 27 Oct 2010 10:49:43 GMT

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!!!

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

marcel_olmo — Wed, 27 Oct 2010 10:59:06 GMT

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.

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

johnw — Wed, 27 Oct 2010 21:50:58 GMT

Autonumber(Row_father)?

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

marcel_olmo — Wed, 27 Oct 2010 23:55:53 GMT

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.