extract text from enumlist

numfon_naka · 08-14-2023 08:15 PM

The Destination Type is an EnumList . I want to select multiple items to display in Google Studio , but I also want to separate the Destination messages individually . but usually choose multiple so up like this Singburi,Chai-Nat,Lopburi but want to separate the text
Let's say I made a Virtual Column and want it split like this. what to do I want to split like this to show the places that I go and go to most often.
D1 = Singapore
D2 = Chai Nat

Try the following formula, it still doesn't work, refer to BernPrzO.
INDEX(SPLIT([CURP],"|"),5)
INDEX(SPLIT([CURP],"|"),3)
INDEX(SPLIT([CURP],"|"),4)
INDEX(SPLIT([CURP],"|"),6)

AleksiAlkio

Something like this should work..

"D1 = "&INDEX([EnumList],1)&"
"&
"D2 = "&INDEX([EnumList],2)&"
"&
"D3 = "&INDEX([EnumList],3)

numfon_naka

my sample data Destination is a column for selecting a location.

AleksiAlkio

And the formula I wrote, will split the EnumList values to separate rows as you requested. If you need something else, explanation would be good, thanks.

numfon_naka

want to separate places Because I want to show in Google Studio how many times I have been to this place.
But I happened to use column Destination as Enumlist, what should I do?
Or how should we separate places to make us know how many times we go to one place?

thank you for the advice and help

AleksiAlkio

For me it sounds you would need to have two different columns, for example one Enumlist for other selections and one for the destination. Then it would be much easier to count how many times you have been and where.