Link to home
Create AccountLog in
Avatar of Vincent Costanza
Vincent CostanzaFlag for United States of America

asked on

extract a line of data from a pdf.

In the attaached pdf I would like to extract the average price only for each commodity. for each month..
Is there a way to do this?
comod-purchases-12-1---11-4.pdf
ASKER CERTIFIED SOLUTION
Avatar of Frank Helk
Frank Helk
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Vincent Costanza

ASKER

I asked that question in a very poor way..

How do I strip the first two lines of data from a cell and leave the last line values.?
Without doing any real coding, after converting the PDF to a more convenient format, I would recommend to follow this algorithm:

Do for every row
      do for every cell in row
           read cell line as string, strip leading whitespace
           if first character is not digit or "$"
               copy to output
             else if first character is a digit
                 discard value, goto next cell line 
                else if first character is a "$"
                 discard, read next cell line and copy it to output, goto next cell
                end if
      end of do for every cell
end do for every row

Open in new window