Replace character for decimal point

[qgpl]

Hello 

I'm trying to run a workflow and currently part of is to change dots to commas and commas to dots as some bank statements use commas instead of dots as their decimal point and use dots as their comma separator. An issue I had recently with my current workflow is when a balance went under 1,000.00 and therefore was formatted as 100.00.

Is there a way I can fix the dot to be two decimal places and remove any other special characters before the decimal point? I don't necessarily need the thousand separators. 

Thanks in advance!

[patrick_mcauliffe · Accepted solution]

So this might have extra steps, but here's how I would do it (assuming this is a string field)

replace(replace(replace([field_name],'.','|'),',','.'),'|',',')

Basically, we replace the dot with some other arbitrary symbol that we know won't be used, then change the comma to a dot, then change that arbitrary symbol to a comma.

Or just remove the dot and replace the comma:

replace(replace(field_name],'.',''),',','.')

[cjaneczko]

Have you looked in the User Settings and tried changing the Thousands Separator to None?

[ahsanaali]

See if this works for you. Cheers 🙂