Replace character for decimal point

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!

Workflow

Output

Tips and Tricks

Transformation

Accepted answers

patrick_mcauliffe

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],'.',''),',','.')

All comments

patrick_mcauliffe

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?

Screenshot 2023-07-12 083929.png

ahsanaali

See if this works for you. Cheers 🙂

2023-07-12_Replace_char_for decimal point.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703