I have a complex pdf file that has that has a table and I want to convert it to csv file. However, due to its complexity I’m having some trouble.
Steps I have done:
Read PDF text “done”
use regular expression to replace dashes “-” with 0 “it changes the whole dashes to zero” it works fine on regexr tool
use regular expression to replace spaces to “|” “it replace the whole spaces”
please follow this video and for replace use following linq
(From r In DT_Data.AsEnumerable Let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace("want to replace ",“expected value”)).toArray() Select DT_Data.Rows.Add(ra)).CopyToDataTable()
