How to search a string inside a text field ?

[Anonymous]

Hello Everyone,

I am looking for a solution where I have to search for a particular keyword, let say "NFR" from a text field.

I tried with CONTAINSSTRING() , Find() in my dax . But nothing helped. Below is my DAX.

        Find NFR = IF ( FIND ( "nfr", LOWER ( [Summary] ),, 0 ) > 0, 1, 0 )

But in stead of searching only "NFR" keyword in a whole, It is also considering "infrastructure", bcoz it has "nfr". I dont want that.

I want only individual keyword "NFR" from the text field.KIndly help.

Thanks In Advance

[amitchandak · Accepted solution]

@Anonymous , Then Search, find and containssting should work

if(SEARCH("nfr",[Summary],,0)>0,1,0) //Search is case-insensitive  , so no need pf lower

[Anonymous · Accepted solution]

Hi @Anonymous 

You may use CONTAINSSTRING function or Search function (like amitchandak  replied before) to build measure or calculated column to find "NFR" in text field. And Find function will recognize letter case, so the result is incorrect.

I build a sample table to have a test.

Measure:

Find NFR 2 = IF(CONTAINSSTRING(MAX('Table'[Summary]),"NFR"),1,0)

Calculated column:

C_Find NFR = IF(CONTAINSSTRING('Table'[Summary],"NFR"),1,0)

Result:

You can download the pbix file from this link: How to search a string inside a text field ?

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , if you only want nfr

then you can do

if(LOWER ( [Summary] ) ="nfr",1,0)

at start

if(left(LOWER ( [Summary] ),3) ="nfr",1,0)

[Anonymous]

I want only these key words in my search.  But "NFR" can be anywhere within the Summary field , which is of 200-300 character length string

NFR

NFR:

NFR -

*NFR*

 Thanks 

[amitchandak · Accepted solution]

@Anonymous , Then Search, find and containssting should work

if(SEARCH("nfr",[Summary],,0)>0,1,0) //Search is case-insensitive  , so no need pf lower