kcep Posted June 25, 2007 Posted June 25, 2007 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.
Lee Smith Posted June 25, 2007 Posted June 25, 2007 (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 June 25, 2007 by Guest p.s.
kcep Posted June 25, 2007 Author Posted June 25, 2007 (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 June 25, 2007 by Guest
AudioFreak Posted June 25, 2007 Posted June 25, 2007 If it's always just 2 zeros you could use this. Replace (Your Field; 1; 2 ; "" ) Michael
LaRetta Posted June 25, 2007 Posted June 25, 2007 A calculation (number ) with numberField will drop leading zeros and it will work in an auto-enter (replace) number as well.
LaRetta Posted June 25, 2007 Posted June 25, 2007 Hi Vaughan!! Yep, but why waste an evaluation if the resulting field needs to be number anyway?
kcep Posted June 25, 2007 Author Posted June 25, 2007 Hi LaRetta, Sorry I'm not tracking with you...can you give me an example of the calculation? Thanks
LaRetta Posted June 25, 2007 Posted June 25, 2007 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.
AudioFreak Posted June 25, 2007 Posted June 25, 2007 This why I like Filemaker, there are so many ways to do the same thing......lol
kcep Posted June 25, 2007 Author Posted June 25, 2007 WOW...thanks LaRetta and Vaughan. Both answers are great. Blessings, kcep
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now