+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Trim numbers(zeros)

Hey. Only been using LL for a few months and im trying to trim double zeros from an number. I’ve tried several functions and combinations of them but nothing seems to work. Do you have any suggestions?

Hi Henriette,

Welcome to our community :slight_smile:.

To get rid of digits, try the Str$() function. Easy sample: Str$(NumberField,0,0) will render the contents of NumberField with no digits (see the hint for the third parameter). Other functions that would also work are Fstr$ or int.

Let us know if this helps.

Thank you for you fast reply. Would this be working for trimming leading zeros for numbers that are irregular?

Do you have an example? Leading zeroes are usually only possible if the field actually is a string field. In this case, you might succeed with Str$(ToNumber(NumberField),0,0)

I’ve also answered your question over on StackOverflow - let’s continue the discussion here and add the final answer over there.