Forum Discussion

sparvez's avatar
sparvez
Helper I
3 years ago
Solved

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, column numbers are unknown. Only one ...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi sparvez ,
    great! You can rewrite like so:
    List.First(List.Select(Record.FieldValues(_), (l)=> Text.Contains(Text.Upper(Text.From(l)), "TV")))

     

sparvez's avatar
sparvez
Helper I
3 years ago

It works ! thanks so much. Just one small thing, if the substring is abesnt, it needs to return 0 , how can I add it ?

Now, it is showing "Error"  if substring is absent.