?

Log in

About this Journal
Links:
My topics Tag management Link management Ground Rules
Current Month
1234567
891011121314
15161718192021
22232425262728
2930
Nov. 23rd, 2009 @ 03:24 pm PDF to spreadsheet (oh, say, Excel)
Tags: ,
Perhaps a pdf contains a table you really want to extract into something real?

Well, as it happens (and I'm unsure when they added it, but at least as of Adobe Reader 9) there is a "Save as Text" function which exports text, including tables. Unfortunately, it sucks for delimitation of that text, so I used UltraEdit in column mode and cleaned it up for import. (manually placing tabs for column breaks). It occurred to me that if I were to do it again, I'd use some script-fu to make that faster, but since the export filter is unfortunately weak for tables, that would require tweaking on a document basis, so I won't describe it further. After that, however, importing it into Excel is pretty much a matter of opening it and adjusting the things you screwed up on. If you wanna paste it in and divide it after, use Data->Text to Columns and delimit using whatever you picked (tabs, in my case)

Of course, the full version of Acrobat has a feature to allow selection of tables by rows or columns and a far more specific output of data that would make this virtually flawless and far nicer, as it could be used to generate the columns without errors. Given that, I'll be willing to bet there are some freeware tools out there that have a similar feature...

Anybody know of one?
(Sumatra PDF has a range selection when you use Ctrl and drag, so it could be used, albeit with a lot of fuss. It does virtually nothing to delimit text in columns, but it can export only the selection, so the columns can be manually differentiated. (That's going to be a problem in most PDF utilities.))
Today we learn...
THENate Gold
Oct. 16th, 2009 @ 05:21 pm Web design
Tags: ,
Web design is the result of several competing philosophies.Collapse )
Today we learn...
THENate Gold
Oct. 8th, 2009 @ 11:18 am Original sin
People have patterns to which we all adhere.

We have limits, beyond which we quit trying. We have hot buttons that anger us. Such foibles are undeniably human, but they can lead to terrible things.

All mankind will, inevitably, choose to do something wrong. We can choose to do right, but we won't always. That choice makes the guilt ours to bear, even though it is inevitable.

The inevitability is sad, because it always remains our choice.
Today we learn...
THENate Gold
Aug. 26th, 2009 @ 01:31 pm Walk in the Spirit
If you walk in the spirit of God, you can overcome your personal weakness.
Luke 18:25-27, Galatians 5:13-18Collapse )
Today we learn...
THENate Gold
Jun. 17th, 2009 @ 03:07 pm Confidence
Current Mood: rejuvenatedrejuvenated
Psalm 27:1
Jehovah is my brightness and my well-being; who should I dread? Jehovah is the fortress of my life; who can frighten me?

Psalm 31:2,3
Bow down thine ear to me; deliver me speedily: be thou my strong rock, for an house of defense to save me.
For thou art my rock and my fortress; therefore for thy name's sake lead me, and guide me.


For those of you who wondered where it came from, this is your answer.
Today we learn...
THENate Gold
Feb. 13th, 2009 @ 03:59 pm Legal theory in brief.
Tags: , , ,
Salus Publica Suprema Lex : The good of the public is the greatest law. ("Salus"has been translated "safety," before, but that overly limits what it means.)
Summum Ius Summa Iniuria : Increasing rules decreases justice.

(These are rough translations. Feel free to post your own.)
Today we learn...
THENate Gold
Feb. 9th, 2009 @ 03:17 pm Human dignity
Tags: ,
Human dignity requires choice. One cannot be dignified if one cannot choose, in their own mind and for their own self, what changes they wish to make to the world. Liberty and dignity are inextricably linked. We owe no debt of allegiance to any government that imposes on our freedoms rather than staunchly protects them.

I've been trying to think of a clear and concise way to say this. That seems to be the simplest form....Collapse )
Today we learn...
THENate Gold
Feb. 7th, 2009 @ 05:40 pm Rich and reckless
Bill Gates probably just got away with over a thousand felonies at once.

Lessee:
Publicly threatening bioterrorism
Felony assault (Threatening death) x Attendees not aware of the joke
Reckless endangerment and battery for those attendees allergic to mosquitoes
Today we learn...
THENate Gold
Feb. 4th, 2009 @ 01:23 pm On Keynes
Tags: ,
Economics isn"t as hard as some people think. It"s also not as easy as others want it to be.Collapse )
Today we learn...
THENate Gold
Jan. 26th, 2009 @ 04:54 pm Set theory for the play of Life
Tags: ,
"Could Be" is a superset of "Shall Be" is a superset of "Must Be."
"Should Be" is also a subset of "Could Be," unless you define "should" as unrestricted to actual possibility.

"Will Be" is an independent set from any of these, recalling, of course, the distinction 'twixt "Will" and "Shall."
Today we learn...
THENate Gold