Forum Discussion
Select text from split function
Hey John Dorrian , tried the expression builder and here you go.
Hope this is what you were looking for and I might have resolved your issue.
If so, kindly mark this reply as an answer or upvote here!
Thanks and regards,
Sunaina Lalwani
I could then duplicate the original column and create another filter for @cy when required.
John Dorrian No need to do duplicacy over the column, you can create a new derived column from this as I assume you need @en as your values, so just split with '|' and then in the next step use another derived column to select an index value prior to '@en' index from split array column from the previous step.
Thanks I did manage the split column part on the |, apologies I am a noob and couldn't find an index value from the list of expression elements.
I've looked at the "byitem" and "byname" functions but can't see how to get these to select the entry with @en in the string.
Hey John Dorrian , tried the expression builder and here you go.
Hope this is what you were looking for and I might have resolved your issue.
If so, kindly mark this reply as an answer or upvote here!
Thanks and regards,
Sunaina Lalwani- Thanks for this I was miles of and making derived columns of derived columns.
Are there any resources you'd recommend using to get a better idea of what functions to use and when, or is it more a case of practice practice and practice with a lot of trial and error.
Kind Regards
John