Specific Filtering Wording

[SH_94]

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

[MilindG]

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

.*(_Rev\>).*

[SH_94]

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]

Hi @SH_94 ..

You can also use this function in Filter tool :

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

[binuacs]

@SH_94 Another method 

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

[MilindG]

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

@MilindGit works, I put . after Rev