Solved: How to extract a text value from an EumList

Eduardo_dos_San · 06-04-2020 10:26 AM

How to extract a text value from an EumList, which is equal to a column of text I have ?

Steve

The language you’ve used is a little confusing. If you already have the column text, why would you want to “extract” it from the EnumList? I imagine two interpretations:

You want to know if the column’s text value occurs in the EnumList. For this, use IN():
```
IN([text-column], [enumlist-column])
```
You want to remove the column’s text value from the EnumList, so that the value no longer occurs in the list. For this, use list subtraction:
```
([enumlist-column] - LIST([text-column]))
```

See also:

View solution in original post

Suvrutt_Gurjar

I believe you may wish to make your requirement clearer with more description or an example. That will help community to offer a better solution.

Steve

The language you’ve used is a little confusing. If you already have the column text, why would you want to “extract” it from the EnumList? I imagine two interpretations:

You want to know if the column’s text value occurs in the EnumList. For this, use IN():
```
IN([text-column], [enumlist-column])
```
You want to remove the column’s text value from the EnumList, so that the value no longer occurs in the list. For this, use list subtraction:
```
([enumlist-column] - LIST([text-column]))
```