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

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