Read PDF Text Multiple REGEX Matches Ienumerable add to DataTable Matches

[Carlos_Diaz_Porras]

I am using the Read PDF Text activity and using the matches activity with Regex, I get more than 200 results in an IEnumerable varaiable.

I am having trouble adding it to a data table. I tried for each item add data row but get an error message when I try item.value

I also tried an assign activity

Left = Dt1
Right = (from m in namematch.Cast(of Match) Select dtResult.Rows.Add(m.Groups(1).toString)).CopyToDataTable

What is the best way to add an IEnumerable variable to a Datatable for multiple matches in the same column new row.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Carlos_Diaz_Porras
Welcome to UiPath community

Build data table and copying those matches to that datatable would be good

How to convert IEnumerable to Datatable?

I’m reading excel row using ''Read Row" which is storing value as variable type ‘IEnumerable’. I want to convert this ‘IEnumerable’ to variable type ‘DataTable’ How to achieve this ?

[Yoichi]

Hi,

@Carlos_Diaz_Porras

I am having trouble adding it to a data table. I tried for each item add data row but get an error message when I try item.value

I recommend to use Named Group of Regex. It returns empty string if there is no match.
If you can share specific your requiremnt, we might be able to suggest some approach.

Regards,

[Carlos_Diaz_Porras]

I found the correct answer on this link

How to extract all values from multiple of the same variable in PDF or Text File

Hi all, I am currently working with an invoice template to extract information from the PDF file. I have also been trying to extract this information from a text file which was converted from the PDF. In the example below, there are multiple tables of payments for each invoice given by the client. Each invoice could have just one or many such tables. I would like to extract all the “Amount Payable” amounts from all such tables. Please let me know how I can do this via text file if possible. [im…