@Middle

Returns FN LENGTH3 characters from inside TEXT/TEXTLIST TEXT1/TEXTLIST1. A start position can be selected FN POSITION2 (starting at 0!) or a TEXT TEXT2 can be specified as the position. Note that TEXT2 is not included in the returned text, even if LENGTH3 is larger than the available text. With a negative LENGTH3 the text to the left of LENGTH3/TEXT3 is returned. The search for TEXT2 is performed from left to right in all cases.

Example: @Middle(TEXT1;POSITION2;LENGTH3)

TEXT1:="Hallo Welt !!!";
POSITION2:=4;
LENGTH3:=8;
@Middle(TEXT1;POSITION2;LENGTH3); returns "o Welt !"

TEXT1:="Hallo Welt !!!";

@Middle(TEXT1;POSITION2;LENGTH3); returns "Hall"

Example: @Middle(TEXT1;TEXT2;LENGTH3)

TEXT1:="Hallo Welt !!!";
TEXT2:="Welt";
LENGTH3:=10;
@Middle(TEXT1;TEXT2;LENGTH3); returns " !!!"

TEXT1:="Hallo Welt !!!";

@Middle(TEXT1;TEXT2;LENGTH3); returns "allo"

Example: @Middle(TEXTLIST1;POSITION2;LENGTH3)

TEXTLIST1:="A*AA*AAA":"BBB*BB*BBB":"CCC*CC*C";
POSITION2:=3;
LENGTH3:=3;
@Middle(TEXTLIST1;POSITION2;LENGTH3);

returns "A*A":"*BB":"*CC"

Example: @Middle(TEXTLIST1;TEXT2;LENGTH3)

TEXTLIST1:="A*AA*AAA":"BBB*BB*BBB":"CCC*CC*C";
TEXT2:="*";
LENGTH3:=3;
@Middle(TEXTLIST1;TEXT2;LENGTH3);

returns "AA*":"BB*":"CC*"

Note : This text was machine-translated and may contain inaccuracies.