replace value(a, list b, list c)
Group |
Searches the text a in b that is regarded as comma separated token list. If a is found, the value at the same position of the comma-separated token list b is returned.
If a is not found in b, an empty text will be returned.
Description of Parameters
Parameter |
Description |
a |
Value to be searched for in b. |
b |
Comma-separated list of search terms. |
c |
Comma-separated list of replace values. |
Examples
Parameter a |
Parameter b |
Parameter c |
Result |
D |
D,A |
Germany,Austria |
Germany |
A |
D,A |
Germany,Austria |
Austria |
I |
D,A |
Germany,Austria |
See Also
replace value(a, name of file b, default value c[, wildcard d])
replace value by range(a, name of file b, default value c[, comparetype d])
replace value(a, csv/xls(x) b, column c, default d, [encoding e, key column f, delimiter g, sheet h]
replace value(a, csv b, column c, default d, [encoding e, key column f])