Filtering using a Filter Table activity where the Filter Option ends in a string

datatable
excel
activities

#1

Good morning. I’ve been using the Filter Table activity which has been very useful however I’m finding some limitations with it.

I am currently filtering a table which contains entries similar to:

AB01
CG05
RD06
ET06
ZA01
LK04

In this case I only want to filter on the entries that end in ‘06’ and as the values can change when future runs of the workflow happen I cannot just list all the entries that contain ‘06’. Similarly there are a large number of entries within this column in the excel sheet and filtering on entries that end in ‘06’ is the easier and quicker way

I look forward to a response.


#2

setting your filter option to {"*06"} should implement an “ends with” 06 filter.


#3

Thank you for answering. That solved it!

I was also wondering for the sake of future UiPath rookies how would you go about including in Filter Options the entries you DON’T want included? An example being:

AC02
DE03
JW05
KL01
BN01
QA02

How would you include in Filter Options that you want to return all entries that DO NOT contain the letter ‘B’ in it?


#4

{"=*B*"} would implement contains filter.

I tried {"<>*B*"} which is how “does not contain” would be recorded in a macro but UIPath gives a range error. Maybe someone at UIpath can enlighten us.