Hi Folks. Do you know how to select multiple text for "does not contain" in advanced filter?

Help StudioX
,
1

I am having multiple text to filter and not sure whats the syntax for this.

image
image1021×561 24.3 KB

2

i have several key worlds to filter out…but the studio give us only two words…hope the question is clear

3

Hi @jomin_antony ,
you can try assigning your does not string collection in a list of strings. Then put a for each for reading the list contents one by one and inside that for each try this filter activity.

Thanks & Regards,
Shubham Dutta

4

Dear Sir, i new to UIPath and techincally weak to understand the response…can you help me how to do it? i wanted to filter out 6 different keywords from a particular column. for now, i can see the “does not contain” option is available for maximum 2 words…can you assist in simple words? a screenshot is attached already

5

Hi @jomin_antony ,
can you send me the sample excel file?
Then I can code everything and send you the file.

6

attached sample data…the column head is highligted in Yellow…and key words to filter out is highlted in green

7

unable to attach the file due to new user restrictions… i can email it or please see the below screenshot

image
image1105×448 10.9 KB

8

Hi @jomin_antony ,
so you want to delete those column data you highlighted in green from the excel right?

9

not to delete…just to filter out ( excluding these data)

10

Hi @jomin_antony ,
Attaching demo code for reference:
Demo.xaml (8.4 KB)

Add the path of input excel in read range and output excel file path in write range.
Add the filters accordingly in Configure filter
image

I have added few but you add accordingly how many you want
image

Thanks & Regards,
Shubham Dutta

11

Dear Shubham,

there is a version conflict. i am using studioX.2020.10.6…how to resolve this?

image
image865×328 15.7 KB

12

in my version, these are the only 2 options available

image
image1426×579 32.3 KB

13

Hi @jomin_antony ,
You are using Studio X.
If you have no problem with working in UiPath studio please use that my project is created in UiPath studio not Studio X.
And if you are new start learning with UiPath Studio rather than Studio X.

Thanks & Regards,
Shubham Dutta