Exact filterByFormula FIND question

[RIck_Allen]

Hey Guys

Is there a do a filterByFormula to find an exact match?

filterByFormula=(FIND(%221234%22%2C%7BProject+Name%7D))

will find records within the Project Name field containing 1234 or 12345 but I need to return the exact match (1234) not the partial match.

Hope that makes sense??

[Bill_French · Accepted solution]

RIck_Allen:

Is there a do a filterByFormula to find an exact match?

I don’t believe there is. Here’s how I do this…

1. Find based on a query that really narrows the result set.
2. Iterate the results performing matching logic.