Question about splitting data into columns: I have one column of data that I'd like to split into seven separate columns. A typical, complete row in the column looks like "mefi:1,ask:3,meta:2,projects:5,jobs:5,music:6,irl:4" where the number values can be anywhere from 1-6. The problem is that if any one or more of the seven subsites are left unanswered, the entire value is missing (there is no "[subsite]:0" or "," as a placeholder). Consequently, separating the column into seven distinct columns using the comma as the separator causes the data to fall/shift into the wrong output columns if any one or more of the seven subsite categories are missing. How can i fix this?
[more inside]
posted by iamkimiam
on Sep 21, 2012 -
7 answers
Please tell me everything I need to know about the GMail dot feature (placing - or not placing - a dot in the username of a gmail email address). I don't understand it, how to use it, what it does and how to take advantage of it. As an email receiver and sender. Also, what problems are created with this? Is there a way I can use it to categorize email, both received and sent?
[more inside]
posted by iamkimiam
on Oct 15, 2010 -
18 answers
