MAP operator not capturing from RegEx

Question

Hello,

I have a collection of attributes that have values like 1 ~ 5, 5 ~ 20, and so on, and I would like to use the Map operator to map those values into something of the type  1 - 5, 5 - 20. Thus, I would like to replace the ~ symbol by the - symbol.

Anyway, like I said, I am using the Map operator to do so and, having selected my attribute,  I introduce a regular expression in the parameter Replace what and "$1 - $2" in the parameter Replace by. That should work, as far as I am concerned, but I don't obtain the expected expression but just a Text field saying "$1 - $2" literally.

What am I doing wrong? I would appretiate some help.

Thanks!

MartinLiebig · Answer

Hi,
Parse Numbers is your friend. It parses strings to numericals.

Best,
Martin

ClaraCaba · Answer

Hello again,

Thank you very much. That regex captured perfectly the two groups I needed for each values. Now I am trying to be able to sum the two numbers captured from the regex. But I can't because they are considered to be text and not real numbers.

Thank you!

MartinLiebig · Answer

Hi,

yes there is
If you use a regex like

([0-9]+).*([0-9]+)

you get the capture groups (...) as $1 and $2

Best,
Martin