AnsweredAssumed Answered

Buggy Middle?

Question asked by flusheddata on Mar 2, 2017
Latest reply on Mar 3, 2017 by flusheddata

Hi,

I've found out that the following functions behave oddly:

Middle ( "Test" ; 0 ; 1 ) = "T" Unexpected result. Should not it be Empty?

Middle ( "Test" ; "" ; 1 ) = "T" Should not it be Empty?

Middle ( "Test" ; 5 ; 1 ) = "" Expected result

 

The same happens with MiddleWords () and MiddleValues ().

 

Why should I use Middle with 0 or Empty? Because I want to set the Start argument programmatically and sometimes it has to be zero.

 

Best regards,

Miguel

Outcomes