This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Removing leading zeros

Posted on 02-27-2024 08:12 AM
Jake_Naude
Silver 4
Silver 4
Reply posted on --/--/---- --:-- AM

I'm using substitute to strip enumlists that have this format...

 

 

AAA-BBB-CCC-020A

 

 

...down to the remaining number + letter like this...

 

 

020A

 

 

Is it possible to remove the leading zero, and not affect the zero on the number 20...?

 

 

20A

 

 

 Thanks in advance... 😉

Solved Solved
0 14 882
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
AleksiAlkio
Gold 4
Gold 4
In response to Jake_Naude
Reply posted on --/--/---- --:-- AM

Then use just a part from it like NUMBER(LEFT(INDEX(SPLIT([Code],"-"),4),3))&A

View solution in original post

Jump to Solution
14 REPLIES 14