Ignore line breaks while parsing pdf with tabula

Asked Nov 08 '21 at 20:22

Active Nov 10 '21 at 11:19

Viewed 854 times

I am trying to read a pdf document using tabula-py. I however have an issue;` on one of the columns, there is a line that breaks the text into a new line and ignores the remaining the text. Here is an example of a column with line breaks

This produces this text when read: "VALUE ADD\rVAT ON NIP\r

How do I make tabula ignore these line breaks? Here is my code:

tabula.read_pdf(file, pandas_options={"header":None}, pages='all', stream=True, lattice=True, multiple_tables=True, guess=False, password=password)

Thanks

edited Nov 10 '21 at 11:19

asked Nov 08 '21 at 20:22

shekwo

1,411
1
20
50

@KJ The funny part is that `"ED TAX #############"` does not show up. Once it breaks, the remaining text on that same line is ignored. `TRANSFER FOR` is also ignored. – shekwo Nov 08 '21 at 20:44
I am not sure I understand what else you want me to do here @KJ – shekwo Nov 08 '21 at 20:59
I guess there is nothing that I can do here since the document is malformed. @KJ – shekwo Nov 08 '21 at 21:13
I can't seem to find any solution to this. Thanks all the same @KJ – shekwo Nov 08 '21 at 21:23
Added another screenshot of the pdf for more context if that helps @KJ – shekwo Nov 08 '21 at 21:33
1

Have you tried with 'lattice=False'? – Talal Siddiqui Nov 08 '21 at 21:47
This does not work either @TalalSiddiqui – shekwo Nov 09 '21 at 10:59

Ignore line breaks while parsing pdf with tabula

0 Answers0