Airtable Record search - partial match
Status: Open · Asked by Shane Harris on · 0 views
I am trying to search for a record in Airtable - the input data contains a full company and trust name, and I need to:
- search records in a table for a partial match (eg if the input data is Geospiza Pty Ltd Trust ATF Tortuga 1535 Trust, I want it to find any record in the table that contains 'Geospiza', but ignores the 'Pty Ltd' as a lot of records will contain that part)
- return the record
I have been playing around with formulas in Airtable, but not having any luck assuming i may need to use Regex, but it is not an area i am skilled in at all
UPDATE - figured it out!!
Hi @shane6836,
Glad to know that the concern has been figured out from your end.
Thanks for the update, and please feel free to reach out to us anytime if you face any issues in the future.