Alteryx Designer Desktop Discussions

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

Convert Number Store as Text in excel to Number in Alteryx

rohit782192
11 - Bolide
'782192

 

How can we convert Number store as Text to Number in Alteryx. In Excel we can do but we can cover in Alteryx.

2 REPLIES 2
alexnajm
17 - Castor
17 - Castor

ToNumber(ReplaceChar([Field], "'",""))

alexnajm
17 - Castor
17 - Castor

I see the like - make sure you also accept the response as a solution to close the thread and ensure other people know it was a useful response. Thanks in advance!

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels