Hey, I'm posting data from a form to google sheets, the only problem is when people copy/paste fields from other word programs.
Take this title for example: 1. It’s been a big year for growth-stage investment in Waterloo Region. Match these companies’ names to the amounts raised. (Use each amount only once) Encoding has Microsofts special quote character etc. Also in between 1. and It's, is a tab, which I change to space because sheets doesn't enjoy \t So from this text, I've crafted the header from the regex: re.compile(r'[^a-zA-Z0-9\-]+') So the entry looks like this: <entry xmlns="http://www.w3.org/2005/Atom"; xmlns:gsx= "http://schemas.google.com/spreadsheets/2006/extended";> <gsx:1itsbeenabigyearforgrowth-stageinvestmentinwaterlooregionmatchthesecompaniesnamestotheamountsraiseduseeachamountonlyonce> test </gsx:1itsbeenabigyearforgrowth-stageinvestmentinwaterlooregionmatchthesecompaniesnamestotheamountsraiseduseeachamountonlyonce> </entry> Still it doesn't pick up the cell. I get a 400 error saying: "Blank rows cannot be written; use delete instead." The header within the spreadsheet is as follows: 1. It’s been a big year for growth-stage investment in Waterloo Region. Match these companies’ names to the amounts raised. (Use each amount only once) Are there docs available saying what the headers regex out / morph into? Where can I find them so I can format this string correctly. Thanks in advance, Jordan -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
