Are regular expressions supported?

Is it possible to search by regular expression or partial cell content?

I have a table of users by zip code. The zips are stored as strings, probably to keep the leading zeroes intact, and I can’t change that. I’d like to search for all users with a zip code in a certain range. It would be easy if they were nums, but they aint. If I could do a wildcard search or a “begins with” search it would also be easy.

Is there a way to do a partial field search, regex, or wildcard search across a table?

There is not a way to do this yet. We’ll likely be adding “contains”, “starts with” and “ends with” back in soon though: https://github.com/metabase/metabase/issues/1422

If you’d like more advanced features like regex could you comment on that GitHub issue or create a new issue?

Thanks.

1 Like