Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Output Issue

henrygeorge
8 - Asteroid

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

AgreementAmount
C12312
RVC89834
C167656
Great78
Cool032

 

Output -

AgreementAmount
Great78
Cool032

 

Please help me

3 REPLIES 3
CharlieS
17 - Castor
17 - Castor

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
8 - Asteroid

@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

NameAmount
Hi RVC125128
YU RIC758129
RERIC999127
Ui C123124

 

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

 

Output

NameAmount
YU RIC758129
RERIC999127

 

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

 

CharlieS
17 - Castor
17 - Castor

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

Labels