Filtering a column of data to return alpha-information only

Hi,

I found in this forum how to use a REGEX along with the "false" path of the Filter tool to pull only those rows where a column does not contain numeric data, REGEX_Match([column name], "\w+"). I placed this in a variable expression and utilized the 'false' of the Filter path to obtain only those rows where that column contains only alpha data. But, some of the cells in the column have dates formatted, YYYY-MM-DD.

Can I modify the REGEX expression to include data formatted like that? Or would I need to use an AND clause in the expression? If the latter, how would I formulate the expression to target date formatted information?

Thank you,

Chris

Expression

Accepted answers

MarqueeCrew

REGEX_Match([NEW VALUE],"\w+") OR 
REGEX_Match([NEW VALUE],"\d{4}-\d{2}-\d{2}")

That should work to test for either condition as TRUE

All comments

mcrew

@Archaeopteryx,

The following expression will find 4 numbers followed by a dash followed by 4 numbers followed by a dash followed by 2 numbers.

Regex_Match([Column Name],"\d{4}-\d{2-\d2")

Cheers,

Mark

MarqueeCrew

@Archaeopteryx,

The following expression will find 4 numbers followed by a dash followed by 4 numbers followed by a dash followed by 2 numbers.

Regex_Match([Column Name],"\d{4}-\d{2}-\d{2}")

Please mark this as the accepted solution. I mistakenly signed in with a wrong account.

Cheers,

Mark

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703