How to convert a pdf file into CSV file?

Question

I want to convert a PDF file into a CSV file. I am using iText library for this. The program is working fine but the output is not in desired format. All the data is coming in first line of the csv file. The output should be exactly same as pdf file(means with line breaks). Please help. Thanks in advance.

Document document = new Document();
  document.open();
  PdfReader reader = new PdfReader("C:\\Indiaops-projects\\PREMIUM_PAID_ACKNOWLEDGEMENT.pdf");
  PdfDictionary dictionary = reader.getPageN(1);
  AcroFields fileds = reader.getAcroFields();
  PRIndirectReference reference = (PRIndirectReference) 
            dictionary.get(PdfName.CONTENTS);
                    PRStream stream = (PRStream) PdfReader.getPdfObject(reference);
                    byte[] bytes = PdfReader.getStreamBytes(stream);
                    PRTokeniser tokenizer = new PRTokeniser(bytes);
                    FileOutputStream fos=new FileOutputStream("C:\\Indiaops-projects\\pdf.csv");
                    StringBuffer buffer = new StringBuffer();
                    StringBuffer data = new StringBuffer();
                    int i=0;
                    while (tokenizer.nextToken()) {
                    if (tokenizer.getTokenType() == PRTokeniser.TK_STRING) {
                        String value = tokenizer.getStringValue();

                        if("x-none".equals(value)){
                            String datastr =data.toString();
                            if(!"".equals(datastr)){
                                buffer.append("\""+datastr+"\",");
                                data = new  StringBuffer();
                            }
                        }else{
                               data.append(value);
                        }
                     }
                  }
            String test=buffer.toString();
            StringReader stReader = new StringReader(test);
            int t;
            while((t=stReader.read())>0)
            fos.write(t);
            document.add(new Paragraph(".."));
            document.close();

Which language are you using? Please add the proper tag. And please show the piece of code used to read the PDF and then generate the CSV so that we can help! — Jean Logeart, Sep 28 '11 at 10:48
If you could share some code which shows currently how you are converting it to CSV, may help us to guide you. — Naved, Sep 28 '11 at 10:48
What does the output look like? What do you *want* it to look like? Show us. — Jean-François Corbett, Sep 28 '11 at 11:14
There is a table in pdf file. But the csv file shows data in only one line. It does not show it in tabular form. — user968880, Sep 28 '11 at 11:30

score 0 · Accepted Answer · answered Sep 28 '11 at 11:50

0

You need to introduce a line break '\n' in the buffer after each table row.

buffer.append("\n");

answered Sep 28 '11 at 11:50

oers

18,436
13
66
75

But how to know that there is an end of the row? – user968880 Sep 30 '11 at 12:30
If you know how many colums there are, then you know the end of each row, you might have to count. – oers Sep 30 '11 at 13:56

How to convert a pdf file into CSV file?

1 Answers1

Linked