Formula to replace

[Ekta]

Hi All, 

I would like to build a formula to replace the second "," with "."

176,044,32

Actually the number should be 176,044.32 but due to readability issue , number is extracted as 

176,044,32.

Please help me with this, thanks a lot in advance.

[atcodedog05]

Hi @Ekta 

Here is how you can do this. You can use this formula. This always replaces last , to .

REGEX_Replace([Input], "(.+),(.+)", "($1).($2)")

Workflow:

Hope this helps : )

[apathetichell]

@atcodedog05's solution should be perfect for the problem you presented, but if for any reason you also have numbers where the format is already xxx,xxx.xx if could parse the wrong comma. If this is the case - try:

REGEX_Replace([field1], "(.+),(\d{2})$", "($1).($2)")

[Ekta]

@atcodedog05  Can i please check what can be the formula to convert the 223.995.40 to 223,995.40?

due to readability issue "." can be read as "," and "," as "." .

if the number is read as 176,044,32 or 223.995.40, how can we convert the number to the correct format ?

Please help me with the formula. 

Thank you in advance

[binay2448]

I think the below formula will help......

REGEX_Replace(Replace([Field1], ".", ","), "(.+),(\d{2})$", "($1).($2)")

[atcodedog05]

Hi @Ekta 

Here is how you can do it.

Workflow:

Formula:

REGEX_Replace(Replace([Field1], ".", ","),
 "(.+),(\d+)", "$1.$2")

The last comma or decimal will be converted to decimal. Also, it can handle n digits after the decimal point.

Hope this helps : )