Remove Leading Zeros

[BenderMatt]

Hi everyone!

I'm looking for an expression that has the ability to look at a string and eliminate leading zeros.  0000017856 to become 17856.  Can anyone assist?

I greatly appreciate it!

[jinivthakkar]

@BenderMatt please find my flow, which replaces 0 with blank values.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[jinivthakkar]

@BenderMatt There is one issue with  my solution is that if the string has 0 anywhere it will removed, so assuming that you will have first 5 characters as 0 and you only need characters after that, we can use substring which will give us correct results even if the later part of the string has 0.

This does not remove 0 from the latter part of the string.

Expression to truncate first 5 characters : 

substring(variables('varZero'),5)

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[VictorIvanidze · Accepted solution]

Much more effective approach you'll find here.

[BenderMatt]

Thank you all, for the help!  That got it!

[VictorIvanidze]

Glad to help.

[plaridel1]

using float() was the simplest solution that worked for me

[Anonymous]

does not work, for values that have zero in the value and bring characters:
- '0000023034'
- '0ABC0D'

in this case how would you apply

[VictorIvanidze]

Hi @Anonymous,

did you test this? 

[TimVW]

Based on this original question/answer I used a Do Until with a check using string function StartsWith: startsWith(variables('TEST'),'0') is not equal to 'true'.

Instead of the check on: first(variables('TEST')) is not equal to 0, which only worked for removing a zero once.

This change resulted in the desired output.

Also, if an empty string can occur put the do until loop in a Condition checking for the string equal to '', otherwise it will fail.

[DrCharlesDBA]

Good day thanks for your solution. Is there a way I can remove leading zeros without a flow?

I am also having a similar problem. I am using a hexadecimals RFID keyboard emulator which writes to text of my PowerApps textbox. I wish to know how can I remove a leading zero. I am scanning a 7 digit barcoded RFID but it comes with a leading zero.

Is there a way I can make the textbox ignore a leading zero on scan or keyboard number typing?
Kindly help.

[VictorIvanidze]

Hi @DrCharlesDBA,

if there exists a way to do that in Power Automate you can do the same in PowerApps, correct?

[SGCWEB]

@DrCharlesDBA

A quick and simple solution if you are using a USB or bluetooth handheld scanner. There is normally the option to program the scanner to ignore 0 prefixes no coding needed just scan some barcodes to program the scanner,

Be careful changing the values of data from barcodes when scanning them at input, often the prefixed 0 is required for the barcode standard used EAN8 etc, If you always want to remove 0 prefix I assume your data field is a numeric.  So just convert the scanned string input to a numeric and the prefix will disappear.  But be careful that the data types are maintained so that you don't have a future issue. It is often better to store the barcode as a string in the correct form for the barcode standard (in cases like inventory products) including prefixes especially when they are registered barcodes, like fully registered product SKU that is internationally unique normally EAN13 or ISBN.  Alternatively use a standard that will not prefix with 0 like code128 which has no fixed length or check digits.  

[VasuSingh]

Just wrap the value in the "int" function - int(YourValue)