AnsweredAssumed Answered

Calculated field won't return words beginning with "Y" or "T" (both UC and LC)

Question asked by MattMinde on Feb 19, 2015
Latest reply on Feb 23, 2015 by philmodjunk

Title

Calculated field won't return words beginning with "Y" or "T" (both UC and LC)

Post

Hi Wise Community!

I made a DB for a local phone directory which takes individual names and generates copy suitable for a printed  directory listing, e.g.:

Field A, Last Name: Doe
Field A, First Name: John
Field B, Last Name: Doe
Field B, First Name: Jane

The resulting calculation looks like this: Doe, John and Jane

I've got six name fields: A, B, C, D, E, and F, with conditionals that allow for different last names, plus a field for an address and two phone numbers. 

Here's the weird thing: ANY name beginning with the letter "T" or "Y" in ANY of the Last Name fields does not show up. I have NOTHING in my calculations which include either of those letters, nor can I figure out where this is happening. I have a script which copies the calculation to an editable field for minor copy clean-up, but this phenomenon appears on entry into the fields. 

Does anyone know what's going on? I've attached a screenshot of the fields and the calculation. I'm using FMPro v6 on a Mac OSX 10.6.8. (I know, old but still works...) THANKS! —MM

TYmystery.jpg

Outcomes