Forum Discussion

bobbybamber's avatar
bobbybamber
Frequent Visitor
8 years ago
Solved

Search a Field Within A Query List

Hi guys,   Apologies if this is obvious/has already been asked - I can't really work out what to even search for to find the answer so figured it'd be quicker to ask. Anyway - I have a dataset o...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi bobbybamber,

     

    Try this calculated column formula

     

    =FIRSTNONBLANK(FILTER(VALUES(Country[Country]),SEARCH(Country[Country],[Text],1,0)),1)

soni27's avatar
soni27
Helper I
8 years ago

MarcelBeug;

 

Great Method, My List is  have like

 

TR

TRQ

TRP

 

The Spliier Picks up TR only even my string has TR and TRQ and TRP; It splits only TR.

 

Text Examples

PT-TR-Test0

PT-TRQ-Test1

PTTTT-TRP-Test2

 

 

Query results

TR

TR

TR

 

TR

TR

 

Results rexpected as :

TR

TRQ

TRP

 

Please share your advise on this