Filtering specific data

muellerme · 2025-01-12T10:27:00.847Z

Hi all,

Just wondering how I can use a filter, maybe with an Extract with Regex, to find any entries under OPRID to contain “Spin #” where # is a number ranging from 0 to 9.

image913×174 3.07 KB

As once it does, I would be making changes to a list of things and change them all to just “Spin”. Unfortunately, I can’t stop the data from entering the database to be called just “Spin” without a number.

Thanks!

Edit:
Currently have this, and it works for some of the data entries but refuses to do all of them for some reason. This did it for Spin 6 and Spin 7 but not 3,4, and 5.

image670×315 15.2 KB

image688×319 16.2 KB

muellerme · 2025-01-12T11:08:40.152Z

Here is the solution that seems to be working:

image678×346 14.1 KB

system · 2025-03-23T10:27:35.397Z

This topic was automatically closed after 70 days. New replies are no longer allowed.