Find string in concatenated string field

[Itayc]

Hey,

I'm trying to find a way to create an indicator that find a string in concatenated string (with | delimiter). the string i'm trying to find should be exactly how it's shown in the concatenated string.

For example: find "paid" in the following examples.
1. "ba_paid" is not equal to "paid",
2. no paid" is not equal to "paid"
3. just "paid" equal to "paid"

between the other tags can but underscore and spaces.

Thanks!

 

[skillilea]

try this, it is case sensitive, if you don't want that use SEARCH

=IF(ISNUMBER(FIND("|paid|", "|"&A1&"|")), TRUE, FALSE)

 

[Itayc]

try this, it is case sensitive, if you don't want that use SEARCH

=IF(ISNUMBER(FIND("|paid|", "|"&A1&"|")), TRUE, FALSE)

Hey @skillilea Thanks for answer, I didn't mention but I need it to PowerBI web platform. it seems your solution is for Excel?

 

[skillilea]

Yep, sorry I missed that.