2 Replies Latest reply on Feb 2, 2011 2:08 PM by dicksmith

    Concatenate text fields which include a hyphen

    dicksmith

      Title

      Concatenate text fields which include a hyphen

      Post

      I have three text fields: city, state, postalcode

      When I concatenate them to define a new calculation field city_state_code, (city_state_code = city & " ," & state & "  " & postalcode) I get different results if the postal code includes a hyphen.

      Example:  city: Weaverviile     state: NC      postalcode:36554     city_state_code: Weaverville, NC  36554

      but       city: Weaverviile     state: NC      postalcode:36554-6554     city_state_code: 365546554

      Something about the hyphen seems to cause problems. This is consistent behavior across multiple records, some with hyphens, others not.  Also, on a layout, Browse Mode, if I click in the city_state_code field, what shows is "Weaverville, NC 36554" but when I click in another field, the city_state_code field reverts to 365546554.

      What's going on, and how can I fix it?  Running FMP7