Forum Discussion

meenakshiramdeo's avatar
meenakshiramdeo
Frequent Visitor
2 years ago
Solved

Find exact substring in string/description

I want to search for exact string in a column and then get a true or false result. For eg If I have to search "AGRESSIVE" or "CLIENT Not" in   "Welcome: This is agressiveness behaviour"   I am cu...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi meenakshiramdeo 

     

    The following method is for your reference:

     

    Sample:

     

    Create a measure as follows

    Measure = IF(CONTAINSSTRINGEXACT("aggressive", MAX([Column])), "True", "False")

     

    or a calculated column as follows

    Column 1 = IF(CONTAINSSTRINGEXACT("aggressive", [Column]), "True", "False")

     

    Output:

     

    Best Regards,
    Yulia Xu

     

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

meenakshiramdeo's avatar
meenakshiramdeo
Frequent Visitor
2 years ago

This will not help as adding space in YourTable[YourColumn] will become " Welcome: This is agressiveness behaviour "