FIND() function

[Muzekker_Vatan]

Hi,
I am using expression below to find "DLV" word in a message.

MID([FSU_DLV], FIND("DLV", [FSU_DLV]), 3)

What if i want to find more words in same message? Like "RCF", "DEP", "ARR" etc.

Thanks in advance.

[AleksiAlkio]

What would be the purpose? Finding the first one?

[Muzekker_Vatan]

Dear Aleksi Thanks for replay.
There is only on of them in each message. Some times it could be DVL and some times could be RCF etc.

[Joseph_Seddik]

MID([FSU_DLV],
  IFS(
    FIND("DLV", [FSU_DLV]) > 0, FIND("DLV", [FSU_DLV]), 
    FIND("RCF", [FSU_DLV]) > 0, FIND("RCF", [FSU_DLV]),
    FIND("DEP", [FSU_DLV]) > 0, FIND("DEP", [FSU_DLV]),
    FIND("ARR", [FSU_DLV]) > 0, FIND("ARR", [FSU_DLV]),
    true, LEN([FSU_DLV]) + 1
  ), 3
)

[Muzekker_Vatan]

Dear Joseph,
Thanks a lot.

[Muzekker_Vatan]

Dear Joseph,
What if i would like to find a text in different table and column?
Example
i have table tamed ABC and a column in  this table named number1
also there is another table named DEF and column in tis table named number2

Looking row in table ABC, how can i say find "DVL" in table DFE in column number2

[Joseph_Seddik]

Use the SELECT() function then. 

[AleksiAlkio]

Something like..

MID([FSU_DLV],
IFS(
CONTAINS([FSU_DLV],"DLV"), FIND("DLV", [FSU_DLV]), 
CONTAINS([FSU_DLV],"RCF"), FIND("RCF", [FSU_DLV]),
),
3)

[Muzekker_Vatan]

Dear Aleksi,
Thanks a lot.