Specific Filtering Wording

Question

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

Rana_Kareem · Answer

@MilindGit works, I put . after Rev

MilindG · Answer

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

binu_acs · Answer

@SH_94 Another method

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