Solved: Get the index number out of list - Page 2

Koichi_Tsuji · 05-18-2020 09:41 PM

Have been thinking around if any of workaround is available to get this done, but need a help from the community.

First of all, I have list type data field, does not matter it is physical or virtual column, like

{val1, val2, val3, val4, val5… } —> length of list is unknown and variable.

Then there is another text files which contain one of the value out of this list.

We have “In expression” to test if this text value is IN the list or not. What I want to achieve is to get the INDEX number if IN expression returns true to know where the text value reside within the list.

Koichi_Tsuji

You gave me a great guide.
I placed your expression as it it, to my sample app, but unfortunately it does not work. After playing around a bit, I found why it does not work, and twisted a expression a bit.
Great new is revised expression finally did a job!

This is expression.

count(
SPLIT(
Left(TEXT([text val]),
FIND( [text val] , TEXT([list]))+len([list])
),
" , "
)
)

View solution in original post