Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
21 - Polaris

@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
15 - Aurora
15 - Aurora

@Koduruhema one way you can do this:

BS_THE_ANALYST_0-1675358749021.png

 

All the best,
BS

LinkedIN

Bulien
Labels
Top Solution Authors