Decimal disappears when column is set to number

#1

Hello!
I am trying to obtain a numeric value from a string, for example:

Input - Our price 13,54
Output - 13,54

Using the following actions, I’ve almost done what I want.
image

Where I am stuck now is that the output looks like this:
image

The regex I use looks like this in step 11:
([0-9]{1,5}.[0-9]{2})

Using regexr to check my expression, it should grab the decimal too. What am I doing wrong?

#2

It’s because of the decimal separator.

Option 1: Replace all ‘,’ with ‘.’ first (then you regex works).

Option 2: Use the “Mlodifiy column(s)” action after your regex with the formula

asnumber([regexprice])/100

Regards,

Jochen