Function EN Version 1.90

@Replace

List Misc Text

Syntax

@Replace(TEXT1;TEXT2;TEXT3);
@Replace(TEXT1;TEXT2;TEXTLIST3);
@Replace(TEXT1;TEXTLIST2;TEXT3);
@Replace(TEXT1;TEXTLIST2;TEXTLIST3);
@Replace(TEXTLIST1;TEXT2;TEXT3);
@Replace(TEXTLIST1;TEXT2;TEXTLIST3);
@Replace(TEXTLIST1;TEXTLIST2;TEXT3);
@Replace(TEXTLIST1;TEXTLIST2;TEXTLIST3);

Description

Replaces in TEXT/TEXTLIST TEXT1/TEXTLIST1 all elements TEXT/TEXTLIST TEXT2/TEXTLIST2 with TEXT/TEXTLIST TEXT3/TEXTLIST3. Thus, TEXT2/TEXTLIST2 specifies a list of text fragments to be replaced by text fragments from TEXT3/TEXTLIST3. If TEXTLIST2 contains more elements than TEXTLIST3, then TEXTLIST3 is padded with empty entries to make both lists the same length.

Example: @Replace(TEXT1;TEXT2;TEXT3)

TEXT1:="Alt1";
TEXT2:="Alt1";
TEXT3:="Neu1";
@Replace(TEXT1;TEXT2;TEXT3);

returns "Neu1"

Example: @Replace(TEXT1;TEXT2;TEXTLIST3)

TEXT1:="Alt1";
TEXT2:="Alt1";
TEXTLIST3:="Neu1":"Neu2";
@Replace(TEXT1;TEXT2;TEXTLIST3);

returns "Neu1"

Example: @Replace(TEXT1;TEXTLIST2;TEXT3)

TEXT1:="Alt1";
TEXTLIST2:="Alt1":"Alt2";
TEXT3:="Neu1";
@Replace(TEXT1;TEXTLIST2;TEXT3); returns "Neu1"

TEXT1:="Alt2";
TEXTLIST2:="Alt1":"Alt2";
TEXT3:="Neu1";
@Replace(TEXT1;TEXTLIST2;TEXT3); returns ""

Example: @Replace(TEXT1;TEXTLIST2;TEXTLIST3)

TEXT1:="Alt1";
TEXTLIST2:="Alt1":"Alt2";
TEXTLIST3:="Neu1":"Neu2";
@Replace(TEXT1;TEXTLIST2;TEXTLIST3);

returns "Neu1"

Example: @Replace(TEXTLIST1;TEXT2;TEXT3)

TEXTLIST1:="Alt1":"Alt2":"Alt3";
TEXT2:="Alt2";
TEXT3:="Neu2";
@Replace(TEXTLIST1;TEXT2;TEXT3);

returns "Alt1":"Neu2":"Alt3"

Example: @Replace(TEXTLIST1;TEXT2;TEXTLIST3)

TEXTLIST1:="Alt1":"Alt2":"Alt3";
TEXT2:="Alt2";
TEXTLIST3:="Neu2":"Neu3";
@Replace(TEXTLIST1;TEXT2;TEXTLIST3);

returns "Alt1":"Neu2":"Alt3"

Example: @Replace(TEXTLIST1;TEXTLIST2;TEXT3)

TEXTLIST1:="Alt1":"Alt2":"Alt3";
TEXTLIST2:="Alt2":"Alt3";
TEXT3:="Neu2";
@Replace(TEXTLIST1;TEXTLIST2;TEXT3);

returns "Alt1":"Neu2":""

Example: @Replace(TEXTLIST1;TEXTLIST2;TEXTLIST3)

TEXTLIST1:="Alt1":"Alt2":"Alt3";
TEXTLIST2:="Alt2":"Alt3";
TEXTLIST3:="Neu2":"Neu3";
@Replace(TEXTLIST1;TEXTLIST2;TEXTLIST3);

returns "Alt1":"Neu2":"Neu3"

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