Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

how to converting string to numbers without front zero

Asteroid

 

How to convert the string to Numbers without the front zero by using a formula?

Thank you. 

 

StringNumber
08181
100100
07272
Highlighted
Quasar

Use the ToNumber formula

 

2018-07-05_15-34-30.png

Highlighted
Pulsar

Should be:

 

ToNumber([String])
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@ll1100000,

 

Alternatively, if you want to keep this as a string and use a different function:

 

TrimLeft([Field],"0")

That will remove all leading zeros.

 

Cheers,
Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels