In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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.

Removing $ sign and comma from number

Johmz
8 - Asteroid
‎03-25-2024 08:47 AM

Hi,

 

Need help to remove $ sign and comma from currency.

 

Input Sample

 

$1,2345.01

$4,5067

 

Output 

 

12345.01

45067

Reply
0 Likes
1 REPLY 1
alexnajm
19 - Altair
19 - Altair
‎03-26-2024 09:28 AM

ReplaceChar([Input], "$,", "")

Reply
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All