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 AgreementAmountC12312RVC89834C167656Great78Cool032 Output - AgreementAmountGreat78Cool032 Please help me

Output Issue

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

Workflow

Help

Accepted answers

CharlieS

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

20191212-RegExFilter2.yxmd

All comments

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

20191212-RegExFilter.yxmd

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+")

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703