Fetch the repeated string from excel cell

Help
1

Hi All,

Thanks in advance.

I am extracting some text from PDF files using Google OCR but it is not giving accurate data.

Here, I need to fetch text from headers in PDF file and it is same for all pages in a file. So, i scanned all pages in PDF file and placed the text into excel file on column wise.

image
image1120Ă—143 5.18 KB

Now, I want to fetch the text which is repeated more times in excel cell on column wise. Could you please help me in this.

Regards,
Lakshman Ganta.

2

@lakshman

Currently I do not have access to UIPath Studio. But I have equivalent code in C#. Understand the below code and try to implement in the UIPath studio.

Before that load Column1 into DataTable. You can use the same following LINQ query in your program and just update the column name in the query.

var dt1 = new DataTable();
dt1.Columns.Add(“A”);
dt1.Rows.Add(“GOOD”);
dt1.Rows.Add(“NOT GOOD”);
dt1.Rows.Add(“GOOD”);
dt1.Rows.Add(“PERFECT”);
dt1.Rows.Add(“PERFECT”);
dt1.Rows.Add(“GOOD”);

        var result = dt1.AsEnumerable()
                       .GroupBy(r => r.Field<string>("A"))
                       .Select(r => new
                       {
                           Str = r.Key,
                           Count = r.Count()
                       });

        foreach (var item in result)
        {
            Console.WriteLine($"{item.Str} : {item.Count}");
        }

The output of above program is -

image

Regards,
Karthik Byggari

3

@Karthik,

Thanks for ur rly. Could you please send me that workflow if you got UIPath studio access. Its very useful for me.

Regards,
Lakshman Ganta.

4

check this out:

and aslo you can use group by as well as mentioned below:

1 Like