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

Group

Basic Functions


Searches the text a in b that is regarded as 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. If e is set to true a subtext search will be performed on the single value of b instead of a check for equality.

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

Description of Parameters

Parameter

Description

a

Value to be searched.

b

Comma-separated list of search terms.

c

Comma-separated list of replace values.

d

Default value if value in a cannot be found.

e

(optional) If set to true, a subtext search will performed, otherwise, the check is for equality. 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