import not exacting?

Nancy Palmquist Nancy.Palmquist at vss3.com
Wed May 7 11:23:17 PDT 2014


Mark,
Do you look at the data in LAZip?
Because the logic that is testing for 5 digits is not triggered, it 
leads me to believe it has 5 digits in LAZip.

Where do you put the LAZip data after you import it?  Where is it when 
you see the zeros missing?

Nancy



On 5/6/2014 4:14 PM, Fairlight wrote:
> On Tue, May 06, 2014 at 02:14:37PM -0400, Kenneth Brody thus spoke:
>> Can you show the actual processing?  A simple import ascii will not
>> strip any leading zeros, unless you put the result into a numeric
>> field.
> Unfortunately, no.  NDA.
>
>>> I'm getting very lucky that lookups seem to match on key field, even with
>>> this screwy non-literal lead-zero translation.  It's always worked, so it's
>>> gone unnoticed until now.  But technically it should always be five digits,
>>> even uncast.
>> Can you double-check that the field is not a numeric field?  That
>> would explain both scenarios.
> It's definitely not cast to anything.  "declare LAZip"  That's it.  What
> was -more- interesting was when I tried to put in a single looping line of
> logic to prepend zeroes on with concatenation if the length was < 5, it
> refused to trigger.  Bizarre.
>
> m->

-- 
Nancy Palmquist
Owner
Virtual Software Systems - www.vss3.com
(412) 835-9417



More information about the Filepro-list mailing list