R on Windows

By default, R for Windows prints no messages while a command is running. Turn this off by right-clicking on the "R Console" window and deselecting Buffered output.

First column CSV

cut -d, -f1

Knime error message

ERROR R Snippet (Local) Execute failed: Must specify non-null table spec and file reader settings for file table.

 This is caused by the R snippet returning a null table (The R variable being NULL)

Knime Tip: control + OK on a config dialog, executes the node.

TIL

Billion laugh attack. Hilarious.

Split line

tr ',' '\n' < input.file

A bash function to list a csv file's headers: (Aliases can't directly take parameters)

csvhd() {
head -n1 $1 | tr ',' '\n'
}

TODO: Update this to properly handle quoted fields.

KNIME memory

Add memory to KNIME.
http://tech.knime.org/faq#q4_2
Done from the knime.ini file for standalone.

Outlook Line Spacing

I use Outlook 2007 at work. (Anyone know why it's so slow?)

Here's how to fix the linespacing

1. Swear loudly and profusely
2. Click on the New button in the upper left to start a new email.
3. Click on the Format Text tab at the top of your screen.
4. You’ll see the buttons are greyed out. Click in the big white box where you’d write the body of your email to activate them.
5. Click on the dialog box in the Paragraph group. The dialog box is located in the lower right-hand corner of the group. It looks like a tiny arrow inside a square.
6. In the section under “Spacing,” change the “Before” and “After” to zero.
7. Change the Line Spacing to Single.
8. Click on the Default button at the bottom of the box.
9. Click OK in the box that pops up.
10. Click OK to get out of the Paragraph dialog box.
11. Surely mutt was better than this?

List adapted from here http://karathecomputertutor.com/2010/02/how-to-change-the-default-line-spacing-to-single-space-in-outlook-2007/ 
 

Broken jobs

begin
dbms_job.broken(job_id,true);
end;

You can get the job ID from

select * from user_jobs;

Jobs can be removed with

dbms_job.remove

Messi

Spotted on the world's number one football blog 101greatgoals.com