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