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 -
How do I force my Gmail account's phone number to associate with the same account's Google Voice number? [more inside]
posted by frodoxiii
on Sep 20, 2012 -
I have an iPhone 4S with iOS 5. If I download iOS 6 tomorrow, will Google maps be replaced
with Apple maps? Meaning, will the upgrade REMOVE Google maps from my phone? If so, will I be able to download a Google maps app? I already have other 3rd party map apps; I want the one that's actually from Google. [more inside]
posted by desjardins
on Sep 18, 2012 -
I like to write using google docs. I used to have a functioning bookmark that was a one-step to new doc solution, which I loved, because it was simple, and efficient. Some time ago that bookmark stopped working, and now it's a matter of several mouse clicks. This is a very small matter, but if someone has a one step solution they care to share, well, that would be delightful.
posted by letstrythis
on Sep 14, 2012 -
How important is Google PageRank in relation to the updates in recent months with regard to Google Panda? [more inside]
posted by MrMerlot
on Sep 12, 2012 -
I have a serious project proposal for Google. I don't need to make money on it, but I'd like to get it looked at. I've been poking around their websites, and have found places to submit business and partnership ideas, but I'm really not sure that those are the right way to submit this concept. It's something on the order of Google Art Project, but different from that. What would you recommend or link me to? Thanks!
posted by Miko
on Sep 9, 2012 -
I want to love Google Apps for Education. On the surface it does everything we want it to do, provide emails for students, offer individual log-in, save items on the Google Server rather than individual computers, provide simple document software, etc. Except that it doesn't..... [more inside]
posted by aetg
on Sep 5, 2012 -
I have multiple email addresses associated with my gmail account. Can I make one of them show up as the default in an original
email's "from" field based on the email address or domain I'm writing to? [more inside]
posted by jessca84
on Sep 1, 2012 -
Is the new Google tablet worth it or practical? As a non-tech savvy person, who has only ever used a desktop, and would like to buy an affordable tablet it would be great to get experienced tech savvy thoughts about this new gizmo that popped up on the Google front page today. Is it safe to walk around with one's tablet connected to wifi, if one's tablet is meshed with one's Google account? Can hackers then access one's Google account easily?
posted by nickyskye
on Aug 28, 2012 -
I'm helping someone setup google apps for a small biz. Already signed up for google apps and bought the domain name through google (enom.com). Need help building a document repo out of GDocs and redirecting the main domain (example.com and www.example.com) to a website hosted on an outside hosting server. [more inside]
posted by WizKid
on Aug 24, 2012 -
I got them ol' wifi blues: I took the plunge and bought a Nexus 7
, primarily to use for reading textbooks. While it works great on my home wifi, at school, it is unable to connect (apparently Jelly Bean and enterprise wifi don't play nice). Can you help me identify what's causing the problem and fix it? [more inside]
posted by ocherdraco
on Aug 22, 2012 -
Need idiots guide to Google+ photo hosting pages? On holidays with sporadic Internet, so limited ability to google or view instruction videos. Spanish friend asked for help por fa [more inside]
posted by Wilder
on Aug 21, 2012 -
If I get a Google Nexus 7, will I be able to use it to reliably read textbooks? My college primarily uses Pearson textbooks for the courses I'm taking. Does anyone have experience with those textbooks on an Android tablet? [more inside]
posted by ocherdraco
on Aug 14, 2012 -
How can I block certain sites from Google search results while preventing Google from tailoring search results just for me? [more inside]
posted by alligatorman
on Aug 9, 2012 -
I logged into Google Chrome on my home computer this morning without thinking much about it via my Gmail account. I immediately noticed my bookmarks bar, web history etc. have all been transformed into the settings from my WORK computer and my home computer bookmarks are gone. I signed out of Chrome, but the work bookmarks are still there. How do I fix this?
posted by the foreground
on Aug 3, 2012 -
Paid Google Apps accounts cannot share (delegate) contacts with users outside of its domain.
Has anybody come across this issue and been able to work around it? [more inside]
posted by Slackjaw37
on Aug 1, 2012 -
Is there any program that can prevent one from searching for specific terms in Google? [more inside]
posted by Clotilde
on Jul 23, 2012 -
I have a question about Google's 2-factor authentication and upgrading to a new device. Can you help? [more inside]
posted by KokuRyu
on Jul 21, 2012 -
What is the relationship between the ritual and the algorithm? Are all rituals algorithmic? [more inside]
posted by 0bvious
on Jul 17, 2012 -
A purchased e-book has disappeared from my iPad.
I would like to have it back, please. [more inside]
posted by SLC Mom
on Jul 16, 2012 -
I googled someone I've been dating for almost 3 weeks and discovered that they had a sibling die in a work related accident just over a year ago. Now I feel I have deeply personal and traumatic information about them without it having been given freely and not sure what to do with it. [more inside]
posted by Dynex
on Jul 13, 2012 -
Question about nearly-identical Wordpress sites hosted at different URLS and Google indexing/rankings. [more inside]
posted by cilantro
on Jul 10, 2012 -
Asking for a friend: Trying to solve a Gmail lockout issue involving moving to another country, deactivating a previous iPhone, and 2-step verification. (Details within.) [more inside]
posted by shakespeherian
on Jul 3, 2012 -
Can anybody confirm for me that I can embed a Google Map on a commercial website in an iframe, without hitting the 25,000 request limit on the Google Maps API, or incurring a lawsuit? [more inside]
posted by randomination
on Jun 29, 2012 -
I use multiple google accounts, and their multiple sign-in feature is generally very helpful to me. I have a work google domain account, managed by my company, and a personal google account. Lately, when I have gone to youtube or google voice, it often associates to my work account, which I do not want. I'd prefer that my work account is only associated with gmail. Is this possible?
posted by Nothing
on Jun 10, 2012 -
It's possible to drag a message to a label in GMail by grabbing it from the leftmost edge. However, on a hi-res monitor, this can be quite difficult. Is there a hack or greasemonkey script that allows you to drag the message by clicking and dragging anywhere in the Subject rather than just the left edge?
posted by I EAT TAPAS
on Jun 10, 2012 -
What is the best way of organizing and managing my thousands of contacts - software, best practices, general ways of thinking about the issue? [more inside]
posted by michaeldunaway
on Jun 5, 2012 -
Is it possible to turn Google Reader's starred items into Chrome bookmarks and vis-versa?
posted by feelinglistless
on Jun 5, 2012 -
Something is hijacking my Firefox and stealthily inserting ads into my Google SERPs (and god knows what else). How do I figure out where its coming from? [more inside]
posted by Elminster24
on Jun 3, 2012 -
Is there a way to use the Google Talk Android App via a web browser on my PC? [more inside]
posted by mrbob14
on May 22, 2012 -
If I make an app using an app builder like Apple Developer, Buzztouch, Mit App Inventor or Andromo, for example, who owns the app? [more inside]
posted by cda
on May 20, 2012 -
Had a plan to scrape a website, but now it's down indefinitely. Google has the site cached, but this makes things kind of complicated. Newbie questions about scraping websites and using the Google cache inside. [more inside]
posted by hot soup
on May 18, 2012 -
This morning about 108 gmail inbox messages vanished. I can find them under "all mail" but i don't know they would leave the inbox. Also, someone's been trying to add an event to my google calendar, with no success.
are these two things related? is there evidence of a hack?
posted by holdenjordahl
on May 13, 2012 -
Currently, I have a Virgin Mobile PAYG smartphone. I'd like to get a phone on my family's Sprint plan instead (for the same monthly price as Virgin, I can get unlimited whatever). However, Sprint says they can't port my phone number because Virgin is a reseller of theirs. I've heard that you can port your number to Google Voice for a small fee, and then have Sprint port the number to a Sprint phone, but this advice was found on a forum somewhere and no one backed up the claim that it actually worked. Would it work? Have you done this? I'd really like to keep my phone number, and before I risk losing it, I'd like to know. Thanks.
posted by bluefly
on May 7, 2012 -
Google contacts seems to be getting increasingly problematic for me. In some contact records, I have over a dozen random email addresses assigned to a contact (that have no relation at all). In others, the contact email is legitimate, but is now named after some individual I have never ever had any form of contact with, apparently through some google+ functionality (I have not signed up for google+).
Aside from ditching this increasingly crappy platform, any advice how it make this work?
I cant see hand fixing thousands of contacts....
posted by dougiedd
on May 5, 2012 -