Extract more than one text from EnumList

Hi everyone! I have a column type EnumList (named "Demanda") that show several options (70+). For that reason, I use numbers before the "request", that works like codes, as follow:

Show More

01 - Request A

02 - Request B

I just want to see this "code" in the Form_view. So, I create a virtual colunm (named Extracted_Demanda) with the following formula:

Show More
MID([Demanda], 6,500)

After that, I insert on Detail_view only the column Extracted_Demanda that shows only the text (e.g. Request A). 

The problem is: If I select more than one option in the column Demanda (EnumList), the results in the virtual column Extracted_Demanda will be present as follow:

Show More
Request A, 02 - Request B

As you can see, only the first part was converted to the formula MID.

@Steve 

0 3 93
3 REPLIES 3
Top Labels in this Space