Alteryx Designer Desktop Discussions

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

Specific Filtering Wording

SH_94
11 - Bolide

Hi Community,

 

I would like to ask how to do specific filtering to ensure only "_Rev" are presented in the output.

 

Data

WKKING_Rev1.yxdb

KIEUR_Rev.yxdb

WYRJE_Rev.csv

W_109_1Rev.csv

181_MD_Reve_wy_Rev.xlsx

EYE_Reve.yxdb

 

 

Output

KIEUR_Rev.yxdb

WYRJE_Rev.csv

181_MD_Re_wy_Rev.xlsx

 

 

Many thanks for the help

6 REPLIES 6
MilindG
12 - Quasar

@SH_94 You can use this below Regex expression to achieve this.

 

.*(_Rev\>).*

SH_94
11 - Bolide

Hi @MilindG ,

 

Thank you for the prompt response. May i know if it is possible to build the regex formula in the filter tool and not use the regex tool in this case?

 

 

Many thanks again.

Rana_Kareem
9 - Comet

Hi @SH_94 ..

 

You can also use this function in Filter tool :

Contains([Field Name],"_Rev.")

binuacs
21 - Polaris

@SH_94 Another method 

 

REGEX_Match([Data], '.*_Rev\..*')

image.png

MilindG
12 - Quasar

@SH_94 Yes you can use the same expression suing regex_match in formula tool.

@Rana_Kareem Contain wouldnt work in this case since one of the data is _Reve(181_MD_Reve_wy_Rev.xlsx)

Rana_Kareem
9 - Comet

@MilindGit works, I put . after Rev

 

Contains.png

Labels
Top Solution Authors