Currently, the is the option to do case like this:
Case$(4,"0|I|II|III|IV|V|VI|VII|VIII|IX|X")
Result: “IV”
I would like to maybe also have somthing like:
Case("ABCD", "AB|CD|AD|ABCD", "Erg1|Erg2|Erg3|Erg4")
Result: “Erg4”
Typical Use-Case would be switch a text within a Table/Field depending on a Variable-Input.