Forum Discussion
Return complete String from multiple columns searched by a susbstring
Hello Altruists,
I am in a complex situation trying to solve for last few days, but see no hope. Can anyone pls help me?
In a table, i have many columns. Some rows have the info of "TV". I need to get the complete string of TV by using substring "TV" in the new added column columntoFindTV. How to do it pls ?
column1---column2---column3---column4---columntoFindxxTV
1xTV---1xRadio---2xLaptop---(null)---1xTV
(null)---3xIpad---2xTV---(null)---2xTV
1xbook---5xRadio---2xPhone---5xTV--5xTV
thank you in advance.
4 Replies
columntoFindxxTV := IF ( FIND ( "TV", 'Table'[column1],, -1 ) <> -1, 'Table'[column1], IF ( FIND ( "TV", 'Table'[column2],, -1 ) <> -1, 'Table'[column2], IF ( FIND ( "TV", 'Table'[column3],, -1 ) <> -1, 'Table'[column3], IF ( FIND ( "TV", 'Table'[column4],, -1 ) <> -1, 'Table'[column4], "N/A" ) ) ) )Hi, I probably made a mistake, its a power query question, I asked the question there. thanks for your time.
Hi, sparvez
It seems that you have found the solution in the post below.
Return complete String from multiple columns searched by a susbstring
If so, please accept your own reply as a Solution to close this thread. Thanks.
Best Regards,
Community Support Team _ Eason
