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 th...
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

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,