import not exacting?
Scott Walker
Scott.Walker at RAMSystemsCorp.com
Tue May 6 11:44:29 PDT 2014
Mark,
I've seen Excel drop leading "0" when an export is produced. I don't know
where you are importing the data from but confirm that the leading zero is
actually in the data you are importing from.
Regards,
Scott
> -----Original Message-----
> From: filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf Of
> Fairlight
> Sent: Tuesday, May 06, 2014 1:27 PM
> To: filePro Mailing List
> Subject: import not exacting?
>
> 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?
>
> 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.
>
> mark->
> --
> Fairlight Consulting
> http://www.fairlite.com
> fairlite at fairlite.com
> (502) 509-3840
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list