Output Issue

[henrygeorge]

Hi Alteryx

This is my input. I want an output in such a way that anything with C + Numbers (for eg 12) will be pushed aside and those that don't meet the rule are output

Input

Agreement	Amount
C123	12
RVC898	34
C167	656
Great	78
Cool	032

Output -

Agreement	Amount
Great	78
Cool	032

Please help me

[CharlieS]

In a Filter tool, use the following expression:

!REGEX_Match([Agreement],".*\C\d+")

Expression breakdown:

! = does not

RegEx_Match( = match by RegEx pattern

[Agreement] = this field

.* = zero or more of any character

\C = the letter "C"

\d+ = one or more digit characters

[henrygeorge]

@CharlieS Thank you for the help. I think what you said would work but let me give a better eg of the issue I'm facing. Please ignore the eg I gave previously -

Input

Name	Amount
Hi RVC125	128
YU RIC758	129
RERIC999	127
Ui C123	124

I want my output to just include those that have RIC + a numbers(more than 1 number). Can you please help?

Output

Name	Amount
YU RIC758	129
RERIC999	127

Would this work? - !REGEX_Match([Agreement],".*\RIC\d+")

[CharlieS · Accepted solution]

Cool. Here's the new expression:

REGEX_Match([Name],".*RIC\d+")

Since we're looking for matches only, the "!" should be removed. "RI" is added to the "C". This also only works if the "\" preceding the C is removed (I forget the rules on this exactly).