Filtering specific data

Need help
1

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.

image
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.

image
image670×315 15.2 KB

image
image688×319 16.2 KB

2

Here is the solution that seems to be working:

image
image678×346 14.1 KB

3

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