Forum Discussion
Finding a specific word in a text string
I assume you are doing this in a calculated column, right? If so, there is either a bug in the software or a bug in the documentation. The documentation says the last 2 parameters are optional, but in my experience they are required.
This should work
=
IF (
ISBLANK ( SEARCH ( "Magnetite", GLF_LDG_ACC_TRANS[NARR1], 1, BLANK () ) ),
"Customer1",
"Customer2"
)assuming I have the columns right and the returned values correct. They may be back to front or wrong
I assume you are doing this in a calculated column, right? If so, there is either a bug in the software or a bug in the documentation. The documentation says the last 2 parameters are optional, but in my experience they are required.
This should work
=
IF (
ISBLANK ( SEARCH ( "Magnetite", GLF_LDG_ACC_TRANS[NARR1], 1, BLANK () ) ),
"Customer1",
"Customer2"
)
assuming I have the columns right and the returned values correct. They may be back to front or wrong
thanks MattAllington your solution of adding in the optional fields worked perfectly. I had to change the customer names around however the formula gave me what I needed.
Giles
Thanks Matt for this solution - it helped me out as well!
Hey Matt,
Is there any way to add a second or subsequent keyword matches in a single statement?
My issue is I'm trying to find a search slicer that will not just search the possible lookups in that column, but actually update data on other visuals when I search a term. For instance, I want to find keywords in social media posts, but as I search in the slicer I want it to update impression/engagements, etc. Your formula works great, but it only works on a single keyword.
Thanks!
