Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎06-30-2021 06:49 AM

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
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
DawnDuong
13 - Pulsar
13 - Pulsar
‎06-30-2021 06:59 AM

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.

Reply
messi007
15 - Aurora
15 - Aurora
‎06-30-2021 07:36 AM

@sriniprad08,

 

You can do this with Replace as well :

 

messi007_0-1625063712465.png

 

Attached the workflow,

 

Regards,

Replace_20210630.yxmd
Reply
0 Likes
Community Live Fifa Workshop
Labels
Top Solution Authors
View All