import not exacting?
Richard Kreiss
rkreiss at gccconsulting.net
Tue May 6 19:23:40 PDT 2014
> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of Fairlight
> Sent: Tuesday, May 06, 2014 4:15 PM
> To: filePro Mailing List
> Subject: Re: import not exacting?
>
> 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.
Mark,
If you are importing zip codes from an Excel created csv file, more than likely the leading zeroes have been stripped off. I ran into this problem a few years back and had to import the zip code into a rj0 field to replace the leading zeroes that had been removed.
Not sure if this is your problem, but that's how I solved my problem.
Richard Kreiss
GCC Consulting
Office: 410-653-2813
More information about the Filepro-list
mailing list