Convert PDF to CSV via Powershell

Question

I am trying to take data from a webform that is generated in pdf format and migrate it to csv so I can use my limited powershell knowledge to automate VM builds. This is all done on linux as well. This is what I have so far and that seems to work, but I need to automate it all so I need to use wildcards as the file names will change.

pdftotext  -nopgbrk './AndyTest-2 - Linux - Debian 10_13.pdf' test.txt

Import-Csv test.txt | Export-Csv test.csv

halfer · Accepted Answer · 2024-09-15 16:16:10Z

0

Cool - it sounds like you've already got 90+% of the solution.

Why not just call your PS script with parameters?

Example:

$PdfFile=$args[0]
$TxtFile=$args[1]
$CsvFile=$args[2]
pdftotext  -nopgbrk $PdfFile $TxtFile
Import-Csv test.txt | Export-Csv $CsvFile

One possible "gotcha" is that apparently have spaces in your .Pdf filenames. One solution is to quote your variable, e.g.:

"$PdfFile"

Look here for more ideas:

edited Sep 15, 2024 at 16:16

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Oct 20, 2020 at 19:36

paulsm4

123k23 gold badges175 silver badges245 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert PDF to CSV via Powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related