replace value(a, list b, list c, default d, [contains-mode e])

Group

Basic Functions


Searches the text a in b (which is interpreted as a comma separated token list). If a is found, it will be replaced by the value that is at the same position in c (also interpreted as comma separated token list). The function returns the replacement value.

If e is set to true, a search matches if a value in b is a subtext of a. If set to false, a and the value in b have to be equal. See examples.

If a is not found in b, value d will be returned.

Description of Parameters


Parameter

Description

a

Search value.

b

Comma-separated list of values.

c

Comma-separated list of replacement values.

d

Default value if value a cannot be found.

e

(optional) If set to true, a subtext search will performed, otherwise, the check is for equality. See examples. Default: false.


Examples


Parameter a

Parameter b

Parameter c

Parameter d

Parameter e

Result

D

D,A

Germany,Austria

Somewhere


Germany

A

D,A

Germany,Austria

Somewhere


Austria

I

D,A

Germany,Austria

Somewhere


Somewhere

DE

D,A

Germany,Austria

Somewhere


Somewhere

AT

D,A

Germany,Austria

Somewhere


Somewhere

IT

D,A

Germany,Austria

Somewhere


Somewhere

DE

D,A

Germany,Austria

Somewhere

true

Germany

AT

D,A

Germany,Austria

Somewhere

true

Austria

IT

D,A

Germany,Austria

Somewhere

true

Somewhere