TrimLZ ( text )
Trims out all leading zeros from the supplied text; if the text includes only zeros then all are stripped out.
Average rating: 4.1 (36 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
For users who work with a lot of legacy data where zeros rather than spaces are used to fill out a field, this function makes it easy to remove the leading zeros, making life easier for the end users who do not want to see all of those leading zeroes.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.