Remove Leading Zeroes from alpha/numeric string

  • This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
Oct 18, 2009
This would probably best be an option added to an existing function: remove leading zeroes whether it is a number or not.

For instance, we get hospital account numbers in the format 0000321654. Obviously, leading zeroes in a true number can be removed by using @eval. But the problem is we also get 0000M321654 or M0000321654 or MX0000321654 from other facilities.

I wouldn't be looking for something to handle "begins with letter(s)", but there should be a fairly simple function/formatting option for "remove leading zeroes from alpha/numeric string".