AnsweredAssumed Answered

Concatenate returns odd result

Question asked by fblack on Aug 14, 2014
Latest reply on Aug 18, 2014 by philmodjunk


Concatenate returns odd result


     Dear All

     I have a problem with a simple table and a concatenate function, that sometimes returns a number instead of the text I expect. I suspect this is to do with forbidden characters, but I need help.

     Each record is of a historical person: first name, last name, year of birth and year of death. All fields are text. The concatenate function (also set to text!) is:  

     First Name & " " & Last Name & " (" & Year of Birth ) & " - " & Year of Death & ")"

     and so, with the fields populated (by composers), I get something like this:

     Dieterich Buxtehude (1637 - 1707) (first screenshot)


     However, Buxtehude might have been born in 1639


     If I enter "1637/39" in the Year of Birth field, or "1637 or 39", then the concatenate field returns "1.6374e+09".  (second and third screenshots). I'm guessing this is a number, (although the fields are all set to text). I've tried Quote and GetText, within Concatenate, to force the function to return strings of text, but to no avail.


     When I click into the concatenate field, I get shown the text result I expect (fourth screenshot).


     I am running FMP 12.0v5 on OSX 10.9.4


     Many thanks