Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Text Search

Good afternoon

Does anyone know how I do (what formula I use) to search the fields that have a certain fragment of a text?

For example, I need to know which rows in the "Description" field of a table have the "ABC" snippet.

DESCRIPTION TEST
ABCX Yes
ABDF No
AGFA No
AFGD No

If I use the IF formula it does not work because it would only search the field that has only the ABC section. But my goal is to know the lines that have this fragment, but not necessarily be ONLY it.
  • Anonymous -

     

    This should do the trick for you:

    Column =
    SWITCH (
        TRUE (),
        FIND (
            "ABC",
            Table1[Description],
            1,
            0
        ) = 1, "YES",
        "NO"
    )

     

     

1 Reply

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar

    Anonymous -

     

    This should do the trick for you:

    Column =
    SWITCH (
        TRUE (),
        FIND (
            "ABC",
            Table1[Description],
            1,
            0
        ) = 1, "YES",
        "NO"
    )