I'm having a problem with a field using zip codes for labels. If I create
it as a text field, it will drop the zeros in front of the numbers like
02664 becomes 2664,
However if I make it a number field, it will drop the - hyphen from and zip
+ 4 address.
How do you work around this problem?
Thanks
Jeff
~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com
On 2007-12-20 13:15:30 -0800, Jefferis NoSpamme
> I'm having a problem with a field using zip codes for labels. If I create
> it as a text field, it will drop the zeros in front of the numbers like
> 02664 becomes 2664,
> However if I make it a number field, it will drop the - hyphen from and zip
> + 4 address.
>
> How do you work around this problem?
> Thanks
The leading zeros are only dropped in number type fields, FWIW. Text
fields retain the leading zeros if they exist in the imported data. If
you're importing from .csv or Excel files, the leading zeros may be
dropped due to Excel, not FM.
To restore the leading zeros, build a calc for the text field that
filters or replaces the imported value.
Test for length, because not all values may have the plus-four numbers.
Case(Length <= 5, Right("00000" & Zip, 5), Right("00000" & Zip, 10))
Appending the zeros and then trimming the length using the Right
function will give you what you need.
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA
On 12/20/07 4:23 PM, in article 476add63@news.bnb-lp.com, "Lynn Allen"
> The leading zeros are only dropped in number type fields, FWIW. Text
> fields retain the leading zeros if they exist in the imported data. If
> you're importing from .csv or Excel files, the leading zeros may be
> dropped due to Excel, not FM.
>
> To restore the leading zeros, build a calc for the text field that
> filters or replaces the imported value.
Thanks.
It must have been an import problem, but I thought the leading zeros were
there when I looked in the recordset.... But turning it back to text works
now. Thanks
Jeff
~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com