Multiply a string variable

Hello! I have a string value for example text format: $9.99, it could also be USD9.99$ or 9.99 UAH. That is, the text is in different places and can be random.

I need to somehow take this value, multiply the number by two, and leave the existing text in the same position. That is, so that out of the existing $9.99 you get $19.98. But I wouldn't want to use loops, as I think it might harm the optimization.

Are there any options? How to separate the number and text separately, multiply and assemble into a whole?

You can try this:

Set v to float(text)

Set text to replace(text, str(v), str(v*2))

My attempt with regex:

You can put it all in one line, if you want.

My attempt with regex:

You can put it all in one line, if you want.

Yes! It works, thanks a lot! I definitely would not have thought of such formulas.