In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Remove dashes

nihou
8 - Asteroid
‎01-19-2021 11:41 AM

What is the best way to remove dashes and decimals from a string? 12-345-6789-12-34 & 12.345.6789.12.34. results wanted: 1234567891234

 

Replace([Field1], "-", "")

 

Replace([Field1], ".", "")

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora
‎01-19-2021 11:48 AM

@nihou,

 

Please see below:

 

messi007_0-1611085645768.png

Attached the workflow,

 

Hope that helps,

Regards,

Test20211901.yxmd
Reply
nihou
8 - Asteroid
‎01-19-2021 12:20 PM

Thank you @messi007 

Reply
messi007
15 - Aurora
15 - Aurora
‎01-19-2021 12:38 PM

@nihou,

 

Happy to help 🙂

 

Best regards,

Reply
0 Likes
Find a local User Group
designer new user guide
Labels
Top Solution Authors
View All