COPYING FROM A PDF FILE TO EXCEL 1

[PrgrmsAll]

Does anyone out there know of a way to copy data (text, delimited) from an Adobe PDF file into notepad, Excel or anywhere that it can be manipulated?

Thank you in advance.

 

[NiteLink]

You can try saving the file as Text file and import the file to Excel or whatever you like.

It depends on whether the PDF has been protected, if the creator has set security preventing others from extracting the file to editablt formats, then you can't save it as other formats.

 

[Scott02]

There is also a program, I believe it's called RedWing that is a product of the same company that makes Monarch. A co-worker was telling me that it can pull data from PDF files. Something you may want to check out.

I'm just learning to use Monarch, but it's a great tool if working with text files that allows you to set "traps" to pull certain data from downloaded reports and export it to Excel for manipulation or appending.

 

[krinid]

Can it pull from protected PDF files? It is freeware/shareware/etc?

 

[BruceReed]

I have used Monarch 3,4,5,6 & found it to be a GREAT software. Never used RedWing, but looked at the brochures. We did not need it & it cost quite a pretty penny (around $2500 if my memory serves correctly, but I might be off by a lot). It will do what you want, if you can afford it.

See

http://www.datawatch.com

Bruce

 

[PeterMoran]

Hi Chris,

I have Acrobat Reader 5 and it has on the right end of the Toolbar an icon with a big T followed by a little dotted square and called Text Select Tool. Click this and then select the required text and it can be copied to the clipboard, and from there pasted to wherever you can paste text.

Under the Text Select Tool icon there is another called Column Select Tool, which lets you select a column of data.

Is this what you were looking for?

Good Luck

Peter Moran
Two heads are always better than one

 

[BruceReed]

Peter

Your answer is much better solution that my tread. You can't beat FREE.

Bruce

 

[krinid]

The text select tool works great for English text, but doesn't work at all for (non-English) 2-byte characters it seems. It can display it well enough on the screen, but pasting it into another app produces garbage results.

I wonder if unicode fonts are okay?