Alteryx Designer Desktop Discussions

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

Replacing / and . in a column

sriniprad08
11 - Bolide

Hi Team,

 

I need help. I have a column with / and ,

I would like to remove / and replace , with .

Please find below

thanks

Sri

inputoutput
/15,2671815.26718
/15,2671815.26718
/15,2671815.26718
/15,2671815.26718
/15,2671815.26718
/15,2671815.26718
/15,2671815.26718
2 REPLIES 2
DawnDuong
13 - Pulsar
13 - Pulsar

hi @sriniprad08 

You can you the Trim and ReplaceChar function, something like the screenshot below.

 

texthandling.PNG

https://help.alteryx.com/current/designer/string-functions

 

Cheers,
Dawn.

messi007
15 - Aurora
15 - Aurora

@sriniprad08,

 

You can do this with Replace as well :

 

messi007_0-1625063712465.png

 

Attached the workflow,

 

Regards,

Labels