Force the zip code to a string and add the optional zeros. Because Excel
will treat 00000-0000 as text, you don't need to worry about dropping
leading zeros, so you only check for a length less than 5...
Example:
strZip = "" + Field("ZIP");
if (Len(strZip) < 5) strZip = Right("00000" + strZip, 5);
MakePostNetBarcode(strZip);
Cheers.
-----Original Message-----
From: Lisa Brooks [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 20, 2007 9:02 AM
To: FusionPro Users Forum
Subject: [fusionpro] RE: Leading Zeros dropping out of PostNet Barcode Rule
Rob,
Still no good. The Tab delimited file drops out the leading zero as well.
Any other thoughts/suggestions?
Lisa Brooks
Brooks Litho & Digital Group
-----Original Message-----
From: Rob Domaschuk [mailto:[EMAIL PROTECTED]
Subject: [fusionpro] RE: Leading Zeros dropping out of PostNet Barcode Rule
Hey Lisa,
Are the zeros definitely in the data? I know Excel has an issue with leading
zeros. What happens if you convert it to a tab-delimeted text file and run
it again?
Rob
-----Original Message-----
From: Lisa Brooks [mailto:[EMAIL PROTECTED]
Subject: [fusionpro] Leading Zeros dropping out of PostNet Barcode Rule
Hi all,
Has anyone experienced an issue with the leading zeros dropping out when
using the PostNet Barcode rule? I tried formatting all cells in my .csv
file to text but that doesn't seem to solve the problem..
Lisa Brooks
Brooks Litho & Digital Group
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Calling all FP Web Users!
Do you have a question or lots of knowledge to share about FusionPro Web?
If so, join our Printable Web to Print Users' Forum today!
Send email to [EMAIL PROTECTED] to find out how!
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Calling all FP Web Users!
Do you have a question or lots of knowledge to share about FusionPro Web?
If so, join our Printable Web to Print Users' Forum today!
Send email to [EMAIL PROTECTED] to find out how!
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact
Printable Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the
recipient. Our privacy policy is posted on www.printplanet.com
--
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Calling all FP Web Users!
Do you have a question or lots of knowledge to share about FusionPro Web?
If so, join our Printable Web to Print Users' Forum today!
Send email to [EMAIL PROTECTED] to find out how!
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable
Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--
