Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

Find string in text and display it in calculated column

Hello,   i have a column with long text. The string within that text I'm looking for has either 001-005 at the end, like that:   Material001, Material 002, Material 003, Material.....   That st...
Show and Tell
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    This calculated column formula works

    Column = coalesce(FIRSTNONBLANK(FILTER(VALUES('Search strings'[Strings]),SEARCH('Search strings'[Strings],Data[OriginalTextColumn],1,0)),1),"Not found")

    Hope this helps.

     

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi Applicable88 ,

 

Is it not possible for you to this transformation upstream in Power Query?

 

Did I help you today? Please accept my solution and hit the Kudos button.