Link Search Menu Expand Document

Convert PDF To CSV (Merge multiline text to table cell) - VBScript

PDF Extractor SDK sample in VBScript demonstrating ‘Convert PDF To CSV (Merge multiline text to table cell)’

' Create Bytescout.PDFExtractor.CSVExtractor object
Set extractor = CreateObject("Bytescout.PDFExtractor.CSVExtractor")

extractor.RegistrationName = "demo"
extractor.RegistrationKey = "demo"

' Load sample PDF document
extractor.LoadDocumentFromFile "sample3_multiline.pdf"

' You can change CSV separator and quotation symbols if needed
'extractor.CSVSeparatorSymbol = "," 
'extractor.CSVQuotaionSymbol = "'" 

' For multiline cell join extracted cell text into single line
extractor.LineGroupingMode = 1 'LineGroupingMode.GroupByRows
extractor.Unwrap = True

extractor.SaveCSVToFile "output.csv"

WScript.Echo "Extracted data saved to 'output.csv' file."

Download Source Code (.zip)

Return to the previous page Explore PDF Extractor SDK