Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6421 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I need to import data. The company I'm importing data from uses leading zeros in their corresponding number field.

ie:

my field: 758426

their field: 00758426

I need a calculation field that will ignore the leading zeros.

Any help would be greatly appreciated.

Thanks.

Posted (edited)

Wow, this is a twist. Usually we're asked about how to preserve them.

FileMaker used to strip the leading and trailing zeros of number in a Number Result Field. However, this was changed. If you are importing into a number field, then the number shouldn't be changed.

Can you give more detail of what you are doing, and what is happening?

Lee

[color:red]p.s.

AFAIK, calculations ignore leading and trailing zeros.

Edited by Guest
p.s.
Posted (edited)

Thanks for your suggestion...

I need to ignore only the leading zeros...not all zeros. Also, I do not want to ignore trailing zeros

ie: 00780508 should have a calculated result of 780508

ie#2: 00507500 should have a calculated result of 507500

Edited by Guest
Posted

A calculation (number ) with numberField will drop leading zeros and it will work in an auto-enter (replace) number as well.

Posted

GetAsNumber( field ) should do the trick, too.

Posted

Hi LaRetta,

Sorry I'm not tracking with you...can you give me an example of the calculation?

Thanks

Posted

Go to your number field - the one you are importing into. Add under the Auto-Enter tab, by calculation. And just insert that same field again. When you leave the calculation, be sure that 'Do Not Replace Existing Value is UNCHECKED. This is based upon your number field being truly a number.

OR

Create a calculation, number. In the calculation box, only insert this number field.

Posted

WOW...thanks LaRetta and Vaughan.

Both answers are great.

Blessings, kcep

This topic is 6421 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.