Database & Application Miscellaneous: Zip code + 4 in labels? FMP 9 Mac.

  • jefferis_nospamme / 212 / Sun, 31 Jan 2010 05:48:00 GMT / Comments (2)
  • 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
  • Keywords:

    zip, code, labels, fmp, mac, database, application

  • http://database.itags.org/database-application/158205/«« Last Thread - Next Thread »»
    1. On 2007-12-20 13:15:30 -0800, Jefferis NoSpamme <jefferisp7...hotmail.com> sai
      d:

      > 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 zi
      p
      > + 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

      lynnallen | Thurs, 22 May 2008 16:03:00 GMT |

    2. On 12/20/07 4:23 PM, in article 476add63...news.bnb-lp.com, "Lynn Allen"
      <lynn...NOT-semiotics.com> wrote:

      > 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

      jefferis_nospamme | Thurs, 22 May 2008 16:04:00 GMT |

  • Database & Application Miscellaneous Questions

    • Your own DNS Server

      I am wondering if any of you have your own dns server, and how difficultit is to setup. I have a cop...

      By johnl_creed, 2 Comments

    • large file stuck in table

      One of our developers has a large problem. He managed to get a 17M file into the db by looping thru ...

      By bastien, 3 Comments

    • Yield function & mouse pointer

      Hi All,I used yield function to get event triggered by user during a process (loopprocess). Before s...

      By anbazhagan, 1 Comments

    • Yargh!

      ''BEGIN GRABBING DATA''If Bookedlbl.Caption = "Yes" ThenSQLString = "SELECT Sala...

      By dj3j, 3 Comments

    • Yet another error with sql & recordset

      Error 3709:The connection cannot be used to perform this operation. It is either closed or invalid i...

      By mintflavor, 4 Comments