Forum Discussion

Flo's avatar
Flo
Qrew Trainee
1 month ago
Solved

Help — Am I doing something wrong? Find() always returns 0 on a Rich Text field

I've been going in circles on this and can't figure out if I'm making a mistake or hitting a platform limitation. Would really appreciate any insight. What I'm trying to do I have a Rich Text field...
  • hueyal's avatar
    hueyal
    1 month ago

    Looks like you have the order of the search string and field switched.

    Try:  

    Find( [Jira ID - Description], "Tool Link"))

     

    Find (Text str, Text searchString)

    Description: Returns the index where searchString starts to appear in str. If not found returns 0.

    Example: Find("Hello World", "Wo") returns 7
    Find("Hello World", "H") returns 1
    Find("Hello World", "X") returns 0