Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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