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
Solved! Go to Solution.
@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+")