Change to numeric type

[BautistaC888]

Hello,

I have a database with the following strings:
303.201,79-
I need to change them into negative Fixed Decimals:
-303201.79

I leave a workflow as an example. If anyone could help i will appreciate it.
Thank you.

[atcodedog05 · Accepted solution]

Hi @BautistaC888 

Here is how you can do it. I am using multi-field formula to apply on multiple columns.

Workflow:

Hope this helps : )

[Sebastiaandb]

@BautistaC888 here you go, couldn't stack the multi fields tough 😞

[Sebastiaandb]

@atcodedog05 haha you were to fast (again ;-)) and stacked it in one tool, awesome!

[apathetichell]

@atcodedog05  - tonumber(regex_replace([_currentfield_],"([\d,\.]+)(-)"."$2$1")) -no?

[atcodedog05]

Hi @apathetichell 

There is one more catch dot should be removed and comma should be replaced with dot. I felt replace to be easier and faster to build approach 😅

[Sebastiaandb]

@atcodedog05 Do you know a way to stack regex formula's in the multi field tool? Would be awesome. Weird thing is that you can put multiple formula's in one formula tool after another that basically does the same for just one field, would be cool to have that functionality in the multi field tool (like first do this regex formula and then...)...

[atcodedog05]

Hi @Sebastiaandb 

You can nest your formulas one inside other 😅

Hope this helps : )

[Sebastiaandb]

@atcodedog05  hahaha best reply i got in a long time! Awesome! Not sure if this wins any beauty competition but hey, it works :D!

[apathetichell]

@atcodedog05- I was going to do the much yucker

tonumber(regex_replace(regex_replace(regex_replace(REGEX_Replace([_currentfield_],"([\d,\.]+)(-)","$2$1"),"\.","|"),",","."),"\|",","))