There are a series of PDF files I would like to convert into table data. The proposed format is SQL, but Excel is OK also, if the former is harder to do. Attached is one sample file.
Is it possible to do this?
Thanks for reading.
Converting PDF document data into table data
Moderators: Dorian (MJT support), JRL
-
Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: Converting PDF document data into table data
Hi,
This is rather vague. I guess what you mean is you want to extract some text from PDF files and put it in a database.
This is probably outside the scope of this forum - certainly there are no native Macro Scheduler functions which could do this but there are third party tools we've used with Macro Scheduler which can be used to convert PDF to text (e.g. www.pdf2text.com), and then you could ReadFile and RegEx the info and insert it into a database.
Happy to try and help with more specific questions.
This is rather vague. I guess what you mean is you want to extract some text from PDF files and put it in a database.
This is probably outside the scope of this forum - certainly there are no native Macro Scheduler functions which could do this but there are third party tools we've used with Macro Scheduler which can be used to convert PDF to text (e.g. www.pdf2text.com), and then you could ReadFile and RegEx the info and insert it into a database.
Happy to try and help with more specific questions.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
