Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Capture data from pdf
#1
Solved: 10 Years, 7 Months, 2 Weeks ago
Hi All,
I have one query.
I want to capture some data from pdf file and want to paste in spread sheet.
That data is coming in following way
Left side some text (say qualification) and on right side name and just below name phone no.
My requirement is i need to capture qualification in qualification column, the name in name column and phone no in phone column in spread sheet.
See the attachment for reference.
[/font]
please let me know the script that how can i do this.

Thanks in advance


Attached Files Image(s)
   
Reply
#2
Solved: 10 Years, 7 Months, 2 Weeks ago
Take the first line of data and split the string after implex take that string as Name

take the second line and split by delimeter : and get the phone number
take the third line and trim it for Qualification
Code:
Function GetPDFPageCount(filename)
Dim pdfFile,Acroapp,pdf
'PDF File preparations
Set Acroapp = CreateObject("AcroExch.App")
Set pdf = CreateObject("AcroExch.PDDoc")
pdf.Open filename,"temp"
Set pdfFile = pdf.GetPDDoc
GetPDFPageCount = pdfFile.GetNumPages
Set pdffile = nothing
Acroapp.Exit
End Function
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Sad Save data from pdf file to a word doc Amar 0 2,394 12-12-2013, 12:29 PM
Last Post: Amar
  Capture data between [BRACKETS] nayak 4 5,049 02-21-2012, 08:56 PM
Last Post: nayak
  How to rerieve data from .xls & compare with data in data table test71 6 6,223 03-10-2008, 04:55 PM
Last Post: test71

Forum Jump:


Users browsing this thread: 1 Guest(s)