AnsweredAssumed Answered

Inconsistent text manipulation behavior for CRLF

Question asked by jbante on Dec 24, 2013
Latest reply on Jan 2, 2014 by TSGal

Summary

Inconsistent text manipulation behavior for CRLF

Product

FileMaker Pro

Version

13

Operating system version

10.9.1

Description of the issue

Text manipulation behavior is inconsistent when a carriage return is concatenated with a line feed (in that order).

Steps to reproduce the problem

Length ( Char ( 10 ) & Char ( 13 ) ) = 2
Length ( Char ( 13 ) & Char ( 10 ) ) = 1
Position ( Char ( 13 ) & Char ( 10 ) ; Char ( 10 ) ; 1 ; 1 ) = 2
Length ( Middle ( Char ( 13 ) & Char ( 10 ) ; 2 ; 1 ) ) = 0

Expected result

Length ( Char ( 13 ) & Char ( 10 ) ) = 1
or at least Length ( Char ( 13 ) & Char ( 10 ) ) = Length ( Char ( 10 ) & Char ( 13 ) )

and Middle ( Char ( 13 ) & Char ( 10 ) ; 2 ; 1 ) = Char ( 10 )

Actual result

Length ( Char ( 10 ) & Char ( 13 ) ) = 2
Length ( Char ( 13 ) & Char ( 10 ) ) = 1
Position ( Char ( 13 ) & Char ( 10 ) ; Char ( 10 ) ; 1 ; 1 ) = 2
Length ( Middle ( Char ( 13 ) & Char ( 10 ) ; 2 ; 1 ) ) = 0

Exact text of any error message(s) that appear

none

Outcomes