Extract more than one text from EnumList

Wariswon

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:

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:

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:

Request A, 02 - Request B

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

@Steve

Suvrutt_Gurjar

Please try an expression as follows in the column [Extracted_ Demanda]

SUBSTITUTE(EXTRACTHASHTAGS(SUBSTITUTE ([Demanda], "- Request ", "#")), "#", "Request ")

The above is not tested. Replying from mobile phone. Please test well.

Wariswon

Thanks for your reply. Unfortunately, this expression didn't work.

The requests are clients' demand (e.g. "01 - Appointment with Dr. John" | " 02 - Payments" , and so on).

Steve

There is no good way to do it with your data structured as it is.