AnsweredAssumed Answered

Line feed char(10), quote() and value based text functions

Question asked by robertnaud on May 12, 2017
Latest reply on May 15, 2018 by TSGal

Using FileMaker 15 on a mac.

Consider the following expression:


List ( quote( "first line" & char(10) & "second line" ) ; "my second value" )


Valuecount of that expression returns 3

(I expect 2 instead)


getvalue (expression;1) returns "first line

(with the opening quote. I expect "first line second line" where the 2 are separated by a line feed)


getvalue (expression;2) returns second line"

(with ending quote. I expect "my second value" instead, without the quotes)


getvalue (expression;3) returns the text my second value

(I expect this to be blank)


The help mentions that values are text items separated by carriage returns. It makes no mention of the line feed character. Actually, the quote function is somewhat irrelevant to my example, other than after quoting something, one expect the resulting text to be considered a single value.


Possible fix is to alter value based functions to disregard line feed character. Alternate fix is to enhance the quote function to replace line feed characters with a symbol like it is done with carriage return (char(13) gets replaced with the pilcrow symbol)



Please let me know if this should be submitted as a feature request instead.

Thank you for your feedback on this.