Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

KRISHNSX
5 - Atom

Item Price = 1,024,00

 

I want to replace it into 1,024.00 

6 REPLIES 6
gabrielvilella
14 - Magnetar

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

binuacs
20 - Arcturus

@KRISHNSX 

 

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

binuacs_0-1645454460977.png

 

KRISHNSX
5 - Atom

Thank you @gabrielviella 👍

KRISHNSX
5 - Atom

Thank you @binuacs 

Koduruhema
5 - Atom

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

BS_THE_ANALYST
14 - Magnetar

@Koduruhema one way you can do this:

BS_THE_ANALYST_0-1675358749021.png

 

Labels