Forum Discussion

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago
Solved

Finding a specific word in a text string

Hi everyone,

 

I have a column which contains text and I need a formula which can find a specific word (Magnetite) and if it finds it in the string to then give me what I want. 

 

I have tried the following formula:

 

IF(SEARCH("Magnetite",GLF_LDG_ACC_TRANS,GLF_LDG_ACC_TRANS[NARR1]),"Customer1","Customer2")

 

IF(CONTAINS(TABLE,GLF_LDG_ACC_TRANS[NARR1],"Magnetite"),"Customer1","Customer2")

 

However it just gives me the answer as Customer2.

 

Here is a picture of the data:

 

 

Thanks,

 

Giles

Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    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

7 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    10 years ago

    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

    • GilesWalker's avatar
      GilesWalker
      Skilled Sharer
      10 years ago

      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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks Matt for this solution - it helped me out as well!

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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!

  • Rodrigo's avatar
    Rodrigo
    Frequent Visitor
    10 years ago

    Hi there, 

     

    So I am having a similar situation but instead of one word I need to find multiple words. On a new column I would like to get a specific word from a text: 

     

    Example: 

     

    Column 1          

    texttexttextUCCCalciotexttexttext

    texttexttextUCCMilktexttexttext

    texttexttexttexttexttexttexttexttextVitamins

    texttexttextWatertexttexttext

     

    Column 2

    Calcio

    Milk

    Vitamins

    Water

     

     

    Thanks in advance

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Rodrigo did you find a solution for your problem? If so, could you please help me out?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      In similar situation. Were you able to get the solution for this one,