Convert pdf file into an Excel File

Hi,

Can you try the following sample?

mc = System.Text.RegularExpressions.Regex.Matches(strData,"(?m)^(?<Order_ID>\S+)\s+(?<Order_Date>\S+)\s+(?<Customer_Name>.*?)\s+(?<Country>\S+)\s+(?<Item>\S+)\s+(?<Price>\$\s+[.\d]+)\s+(?<Quantity>\d+)\s*$")

arrCol = dt.Columns.Cast(Of DataColumn).Select(Function(dc) dc.ColumnName).ToArray()

In AddDataRow

arrCol.Select(Function(c) CurrentItem.Groups(c.Replace(" ","_")).Value).ToArray()

Sample
Sample20240126-1.zip (4.0 KB)

Regards,

4 Likes