import not exacting?
Kenneth Brody
kenbrody at spamcop.net
Tue May 6 11:14:37 PDT 2014
On 5/6/2014 1:26 PM, Fairlight wrote:
> I'm using import in some code, and noticed that I was ending up with
> 4-digit zipcodes after the import. Thing is, they're ones which start as a
> zero.
>
> If I were using a cast variable for intake, I'd expect this. However, I'm
> using a wholly uncast variable. Shouldn't it import -literally- into an
> uncast variable?
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.
> 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.
--
Kenneth Brody
More information about the Filepro-list
mailing list