Importing PDF's

[Juggy]

I'm looking for an app than can import a PDF document into excel so i can sort the columns alphabetically instead of by date.

 

[bwana]

Copy and paste?

 

[Juggy]

Doesn't work because PDF's are like images.

 

[Fudzy]

Most PDFs are like images. If they're created by a PDF 'printer' they'll still be selectable. If it is a scan/fax the only option is OCR software. I've had semi-success with an app called Omnipage Pro. It's quite pricey though.

 

[Juggy]

It was emailed to me, it's CC statement for the company I work for, they'd like to group items alphabetically instead of by purchase date as there are lots of car hire/airline tickets etc.

 

[bwana]

Doesn't work because PDF's are like images.

In a properly made pdf fonts are actually embedded into the document as text. Unlike a scanned image these are selectable.

 

[Nod]

Ask them to sort it different and resent?

 

[Juggy]

Ask them to sort it different and resent?

Tried that already, FNB aren't very helpfull

 

[dotVIBE]

does none of the hundreds of google results work for you? I've converted PDF files to AutoCAD format, so excel should be a snap.

 

[Juggy]

does none of the hundreds of google results work for you? I've converted PDF files to AutoCAD format, so excel should be a snap.

I like to ask people so I can get the best results first time. Besides, our bandwidth at work is shocking so downloading a 30MB file take about an hour.

Thanks for your help, I think

 

[Bcm]

Some PDF's have embedded DRM that removes the copy and paste function.

If that's the case, then you'll have to use OCR software.

What are the document security settings? Ctrl+Alt+S ?

 

[Nod]

Can they just send you a csv file?

 

[Abe]

Fox Editor will let you edit and copy from PDF's

http://www.foxitsoftware.com/pdf/pe_intro.php

They also have a nice slim PDF reader (3 Meg) which is free

 

[bwana]

Some PDF's have embedded DRM that removes the copy and paste function.

If that's the case, then you'll have to use OCR software.

What are the document security settings? Ctrl+Alt+S ?

Or give it to a guy with a mac - there are more ways around it than I can readily list on that platform.

 

[Skeptik]

Adobe Acrobat (8) does pretty decent OCR work. Even better than Omnipage. They also have various converters.

 

[kapovski]

Nope. FNB dont send credit card statements in any format apart from PDF. Very irritating.

 

[bekdik]

have a look at http://www.solidpdf.com/

 

[Skeptik]

Clearly they don't want anyone forging a statement or changing it.

 

[Abe]

Clearly they don't want anyone forging a statement or changing it.

Changing a PDF is the easiest thing in the world. Open it up with a Hex or Text editor and go mad. As long as you adhere to the format which is available publically.