How to Replace comma ( , ) with " . " from the end of the String

[KRISHNSX]

Item Price = 1,024,00

I want to replace it into 1,024.00 

[gabrielvilella · Accepted solution]

Hi @KRISHNSX, you could do something like REGEX_Replace([Item Price], '(.+),(\d+)$', '$1.$2') in the formula tool. 

[binu_acs]

@KRISHNSX 

REGEX_Replace([Item Price], '(.+)(\,)', '$1.')

[KRISHNSX]

Thank you @gabrielviella 👍

[KRISHNSX · Accepted solution]

Thank you @binuacs 

[Koduruhema]

I want to swap vinod,shetty to shetty,vinod
how can i do this ?

[BS_THE_ANALYST]

@Koduruhema one way you can do this: