Need to get the count of string in application region

Help Apps
, ,
1

@NIVED_NAMBIAR Bro here is the another question bro
i need to get this count ( The Count of values under “Scop”)

image
image947×354 25 KB

How i need to give regex for this

And the process is like if there is three count we need modify based on excel by clicking editare
If not we need to click on introducere and need to do the process based on excel sheet

2

Hi @Sudharsan_Ka
can u show the output of screenscrapping here ?

3

image
image875×631 24 KB

4

Hi @Sudharsan_Ka
use the data from the screenscrapping to generate datatable actvity, it will generate a datatable according and then u can get the number of values under a partuclar column

5

Comunicari in vederea derularii contractului de furnizare e.e.
Comunicari Marketing, campanii si comercializare produse
Participarea la sondaje de piata

6

I thought we can get the value as regex you told me earlier whether that method is possible here bro

7

I will try this one and let you know

8

Did it worked bro?

9

Working on it bro

10

if possible can u share the complete data which u got from screenscrapping here

11

How to count the datatable bro after generating

12

Sure bro

13

if the datatable variable is dt , then use dt.Rows.Count

14

yes bro it worked but it also taken the heading also as row
and showing the count as 4
image

15

Hi @Sudharsan_Ka
Can u share the screenscrapping results [ complete]?

16

Sure bro,Just a minute bro

17 
                                     Scop:                                                                      Optiune:                telefonposta electronicaservicii postaleOricare mijloc Data modificarii

Comunicari in vederea derularii contractului de furnizare e.e. Acord Dezacord 18.05.2021
Comunicari Marketing, campanii si comercializare produse Acord Dezacord 18.05.2021
Participarea la sondaje de piata Acord Dezacord 18.05.2021

image
image874×656 24.2 KB

image
image871×661 24.1 KB

18

Hi @Sudharsan_Ka
i just tried and found we don’t need to use the gernate datatable here,

use this regex on the output of screenscrapping to get the no of item under the Scope column

count=System.Text.RegularExpressions.Regex.Matches(input_string,“.*(?=Acord)”).Count

where input_string is the output of screenscrapping

the count variable will give the number of item under scope column

Regards,
Nived N
Happy Automation

19

Okay bro i will try this and get back to you

1 Like
20

Bro it is showing the result as six