Recent Posts

301

Living Room / Re: sort and filter

« Last post by Target on January 14, 2016, 04:31 PM »

split it into 2 columns, ie DATE | SONG, then your pivot should be able to show the dates across the top, and songs down the left (use a count function)

302

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« Last post by Target on January 12, 2016, 11:57 PM »

[ Invalid Attachment ]
Family uses Airbnb, accidentally rents marijuana grow house

-Arizona Hot (January 12, 2016, 11:07 PM)

that's what happens when you book via silk road...

303

General Software Discussion / address lookup tools

« Last post by Target on January 07, 2016, 06:21 PM »

As part of a larger data cleansing exercise I'm looking for suggestions for an address lookup tool - I have about 2K (Australian) addresses where I need to lookup the corresponding suburb.  The tough part is these are all intersections (eg smith and george st's) so tools that look for specific addresses (eg 10 smith street) probably won't cut it

304

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« Last post by Target on January 05, 2016, 11:38 PM »

305

General Software Discussion / Re: Assemble PDF documents

« Last post by Target on January 03, 2016, 11:14 PM »

I put pages 1,35 , but I see only produces two pages. How can I indicate to print from page 1 to page 35 both included ?

-Contro (January 03, 2016, 09:49 PM)

again, you need to make sure you understand the PDFTK syntax - short answer is that the source files are aliased, ie

• A=file1.pdf
• B=file2.pdf
• C=file3.pdf

where file1 is referenced using the alias of 'A', file2 of 'B', and file3 of 'C' (note they MUST be upper case, but the script does this for you)

When inserting pages you use the alias's as follows

     a1,b1-5,c10-end

this should concatenate page 1 from file1 AND pages 1-5 from file2 AND all pages >= 10 from file3 in a new file

if you just want to concatenate the entire files leave the page number field blank and the files should be concatenated in the sort order

306

General Software Discussion / Re: Assemble PDF documents

« Last post by Target on January 03, 2016, 11:08 PM »

this is where you're going to need to read up on the PDFTK usage

it's a good reason to make sure you're as clear as possible about ALL your requirements upfront

let us know how you get on

307

General Software Discussion / Re: Assemble PDF documents

« Last post by Target on January 02, 2016, 05:38 AM »

try this - you'll probably want to read up on the PDFTK syntax so you know what its doing, but...

load files singly or drag and drop a list, then sort accordingly

enter the desired pages as a comma separated list (the script uses aliases, so you need to understand their use)

enter the output file (full path)

click the check string button to see what the output looks like (probably a good idea before you press go)

copy the output to the clipboard or just press run (run will create a batchfile, run it, then delete it)

script must go in the PDFTK folder

308

General Software Discussion / Re: Microsoft Word seems the most stupid thing

« Last post by Target on December 29, 2015, 11:14 PM »

I thought of that, but its not exactly intuitive, and he would need to be able to clearly lay out all the steps.

if it was laid out in a text file I suppose you could read that into a batch...hmmm...

309

General Software Discussion / Re: Microsoft Word seems the most stupid thing

« Last post by Target on December 29, 2015, 06:12 PM »

just to be clear on this

if you have multiple PDFs you want to combine - this is doable using existing tools

if you have multiple PDFs that you want to cut up and combine in some automated fashion, you're pretty much out of luck

I've never used it but you probably need something like adobes authoring tool (or equivalent) to manipulate PDF's in the manner you seem to require

310

General Software Discussion / Re: Microsoft Word seems the most stupid thing

« Last post by Target on December 28, 2015, 09:48 PM »

so why not use a dedicated tool like PDF split and merge instead of kludging it with word (I assume you're using word to establish some sort of work flow)?

311

General Software Discussion / Re: Microsoft Word seems the most stupid thing

« Last post by Target on December 28, 2015, 08:06 PM »

apologies for the dumb question, but just what are you trying to achieve?

it sounds like you're embedding a PDF into a word document and expecting it to behave like a normal word doc, but I'm not sure (FWIW it won't). 

Also important to know how you're embedding the file as this has implications for its behaviour

You can copy and paste the content from a PDF into word, though different versions might give a different experience

312

Post New Requests Here / Re: IDEA: gui for configuring keyboard shortcuts for J. River Media Center

« Last post by Target on December 22, 2015, 03:23 PM »

Here is a script for you written in AutoHotkey.

-lifeweaver (December 22, 2015, 02:41 PM)

looks like you forgot to attach the script

313

N.A.N.Y. 2016 / Re: NANY 2016 Pledge: Iconus - a handy dandy icon viewer

« Last post by Target on December 20, 2015, 04:24 PM »

is there a download link?

314

Living Room / Re: help with data matching

« Last post by Target on December 17, 2015, 03:46 PM »

gotta love the value we place on data integrity

315

Living Room / Re: help with data matching

« Last post by Target on December 16, 2015, 08:52 PM »

this should be reasonably safe (what could possibly go wrong?)

the attached lists a bunch of entries that I've already matched - it's by no means complete, but it's a start

note that it's actually in CSV format so you can just change the xtn

316

Found Deals and Discounts / Re: Partition Wizard Pro 9.1 - Free for subscribing to Gizmo's newsletter

« Last post by Target on December 16, 2015, 04:08 PM »

For those people who stumble onto this thread and don't know about Gizmo's Freeware newsletter/website (here), it' may be the best, most trustworthy, most wonderful freeware site on the planet.

-mouser (December 16, 2015, 01:53 PM)

present site excepted

317

Living Room / Re: help with data matching

« Last post by Target on December 16, 2015, 03:35 PM »

I can pull the postcodes easily, and likewise derive corresponding suburbs.  Trouble is their data doesn't necessarily match my data (and in many cases is just plain wrong)

which brings me back to the street address.  I'd be interested in how I might go about building some sort of regex tool, but given the variables I'm not sure how I would even go about it

318

Living Room / Re: help with data matching

« Last post by Target on December 15, 2015, 09:37 PM »

so basically I'm just going to have to slog my way through it - luckily it's only small (4.5K records)

319

Living Room / Re: help with data matching

« Last post by Target on December 15, 2015, 06:33 PM »

the data is AU (whats the 'only' part?)

320

Living Room / help with data matching

« Last post by Target on December 15, 2015, 04:49 PM »

looking for some helpful suggestions regarding a task I'm currently trying to complete at work

I have 2 sets of data that I'm trying to match.  The common fields are address details, however they are all free text and there are no common conventions in use.  To compound the issue we can also toss in random abbreviations (still no common conventions), a limited field length (some entries don't have spaces), random pieces of extraneous info, and poor data quality(HA!).  I've been bashing my head against this for a while now without success and have come to the conclusion that I'm going to have to tackle it line by line, though I'm still holding out hope that there might be a better way

the data is clearly potentially sensitive so I can't really supply much in the way of examples, but any idea's?

321

Living Room / Re: Game developer laments gaming industry marketing/psychological warfare

« Last post by Target on December 14, 2015, 06:45 PM »

Just to add (didn't want to rant anymore than I already was), that the whole thing rang as disingenuous, when Star Citizen and f2p browser games are apples and oranges, and applying the same broad stroke to both is a recipe for the same type of regulation that we have today.

-wraith808 (December 14, 2015, 06:06 PM)

I don't disagree with you about this.  More government regulation isn't the answer, but some self regulation would be a good thing. 

Unfortunately I think the former is probably required in order to get anything like the latter...

322

Living Room / Re: Game developer laments gaming industry marketing/psychological warfare

« Last post by Target on December 14, 2015, 05:10 PM »

That bias in this case can be summed up very well:

“Hi, I’m from the games industry. Governments, please regulate my more successful competitors.”

Always remember:

“The ultimate result of shielding men from the effects of folly is to fill the world with fools.”

-wraith808 (December 14, 2015, 04:21 PM)

both of these are valid viewpoints

with respect to the first, successful doesn't mean better (or even good), which is what I think was the nub of his complaint (I know nothing about star citizen, but the voice in my head was screaming duke nukem!!)

and with respect to the latter there's another quote about if you tell a lie for long enough it becomes the truth.  Seems to me that we could well be filling the world with fools, simply because all we're giving them is lies advertising

323

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« Last post by Target on November 12, 2015, 03:33 PM »

or for those who are more 'hands on'...

324

Living Room / Re: Is Excel the most dangerous software in the world?

« Last post by Target on November 11, 2015, 06:44 PM »

I'm reminded of that old truism about a poor tradesman always blaming his tools

325

General Software Discussion / Re: excel tool - cloud or home base?

« Last post by Target on November 05, 2015, 03:22 PM »

you do know that excel will import from a web page. 

Without knowing some more of the specifics its hard to say if this is useful or not, but worth considering