Store pattern in variable

Help Studio
, , , ,
1

Hi,

I want to store some pattern in variable . this pattern looks like this

Change page: < 1 2 3 4 5 6 7 8 9 10 … > | Displaying page 1 of 20, items 1 to 50 of 957.

Change page: < 1 2 3 4 5 6 7 8 9 10 … > | Displaying page 2 of 20, items 51 to 100 of 957.

and it continues like this.

I have tried var abc= “Change page: < 1 2 3 4 5 6 7 8 9 10 … > | Displaying page*” but it’s not working…

can someone suggest?

2

Hi @chiranjit.saha1,

Can you clarify what you want to achive?

3

You should check that it works using the selector editor or UiExplorer without the variable.

I would probably wildcard lot more of that:

abc = "*Displaying page*"

Regards

4

Actually this patterned data came to my excel sheet when I scrape value from webpage. so I store this data in variable , later delete it from excel whenever occurrences came

I’m assigning
arrayDelete= ExtractDataTable.Select(“[Clerk Code]=‘Change page: < 1 2 3 4 5 6 7 8 9 10 … > | Displaying page*’”), later invoke a method to delete it from excel

5

@chiranjit.saha1 If I’m Not Wrong, you would get that Unwanted data in the rows of Excel and you would want to remove them. If that’s the case, and if these values always start with “Change page”, you can exclude that row. Is this what you wanted to do ?

6

yes absolutely

7

@chiranjit.saha1 Have you tried with a more simpler and ready approach using Filter Datatable ? If you get the right data using that then you can it would be a better method. Something in the below way, If not we can modify the Select Method to get you the required data.
image

8

I used filter data table but in excel same pattern came. it doesn’t delete

image

image

9

@chiranjit.saha1 is it possible to provide the excel file ?

10

I’m sorry, due to security issue i can’t able to provide