When you save a file with leading zeros as a text file - either .CSV or .txt
the leading zeros ARE there. But in one of those Heisenberg Uncertainty
Principle moments, the act of observation distorts the result. When you open
the .CSV or.TXT files with Excel, you will lose the leading zeros and you
will think that you have lost your mind. If you open the data file with
Notepad or other text editor you can verify that your zeros are indeed
there.
You could keep a copy of the data in .XLS format to preserve the leading
zeros and regenerate the .CSV as needed.
There is a built-in rule for padding fields with leading zeros. In
JavaScript it looks like this:
Var1="Zip";
LeadingZero="00000";
return FormatNumber(LeadingZero, Field(Var1));
Spencer Whetstone
-----Original Message-----
From: Lisa Brooks [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 20, 2007 12:02 PM
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
--
