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.

Try

Substitute (Your Field ; "0" ; "")

Michael

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 June 25, 200718 yr by Guest
p.s.

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 June 25, 200718 yr by Guest

If it's always just 2 zeros you could use this.

Replace (Your Field; 1; 2 ; "" )

Michael

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

GetAsNumber( field ) should do the trick, too.

Hi Vaughan!!

Yep, but why waste an evaluation if the resulting field needs to be number anyway?

Hi LaRetta,

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

Thanks

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.

This why I like Filemaker, there are so many ways to do the same thing......lol

WOW...thanks LaRetta and Vaughan.

Both answers are great.

Blessings, kcep