Hi,
Is it possible to change the list delimiter for table[row] to something else, just as can be done in a virtual colum?
Thanks in advance, Jan
No. But perhaps you can do it within an expression with:
Maybe, but the intention is to find an exact match for the value of a row from column [Name] in one of the rows of the column [Data] in the Texts table, Because the find expression is almost the only expression that is case sensitive, I worked with the this expression:
find(" , " & [Name] & " , ", " , " & Texts[Data] & " , ")
If the delimiter " , " is present in a [Data] row, it also will be considered as a delimiter.
Probably I can work with the substitute expression to make sure that the delimiter " , " is not in the [Datra] column of the Texts table,
Maybe if you can further describe what you’re trying to do, someone could suggest a solution.
User | Count |
---|---|
18 | |
10 | |
8 | |
6 | |
5 |