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