Delete/Filter Rows in Which a Cell Doesn't Meet a Specific Format

I have a set of data that looks like the following:

Input:

I wish to remove all rows in which the Project is not a 10 digit value.

Output:

I have tried the following using the filer tool, but it did not work. I have tried a few different methods with no success.

Next, after filtering the data, I want to add two letters PR infront of the project name values to make it look like the following:

Follow up question, where can I practice regular expression problems online? I want to get better at them. Thank you.

Help

Accepted answers

Hey @shaheer the first step would be to perform a filter based on a regex_match() of 10 digits:

REGEX_Match([Project Name], '\d{10}')

To add 'PR' to the front of these values, that's a simple addition expression:

For testing expressions before using them, sites like https://regex101.com/ are brilliant.

The basic filter does not support regex.

You can do a custom filter: Length([Project Name]) != 10

Hey @shaheer the first step would be to perform a filter based on a regex_match() of 10 digits:

REGEX_Match([Project Name], '\d{10}')

To add 'PR' to the front of these values, that's a simple addition expression:

For testing expressions before using them, sites like https://regex101.com/ are brilliant.

But if I do length != 10, it would include non-digit characters. I only want the 10 digit numbers.

Hi @shaheer Understood, @DataNath has you covered!

Awesome, both of these work perfectly. Thank you so much and thanks for the links as well!