February 20, 2011

[SOLVED] GoogleDocs: How to download the spreadsheet as xls

For example you found some nice Google Docs Sheet

https://spreadsheets.google.com/pub?key=0ArURTcbhh9uWdGdTVEFFM3FadVlMUE91QVRMQ0VGaFE

and would like to save this document as Excel file. Just add at the end of the URL "&output=xls"

https://spreadsheets.google.com/pub?key=0ArURTcbhh9uWdGdTVEFFM3FadVlMUE91QVRMQ0VGaFE&output=xls

also you may like to switch into edit mode (if you have enought rights). Just replace "pub" with "ccc"
https://spreadsheets.google.com/ccc?key=0ArURTcbhh9uWdGdTVEFFM3FadVlMUE91QVRMQ0VGaFE

Source: googlesystem.blogspot.com

February 18, 2011

[SOLVED] SVN: Parse all changes by user in defined time period

Parse all changes by user in defined time period
svn log -v -r{"2011-01-01 00:00:00"}:{"2011-02-18 00:00:00"}| sed -n '/m.kupriyanov/,/-----$/ p'

Source: stackoverflow.com

February 1, 2011

[SOLVED] SQLite Single quotes in the query expression

A string constant is formed by enclosing the string in single quotes ('). A single quote within the string can be encoded by putting two single quotes in a row - as in Pascal. C-style escapes using the backslash character are not supported because they are not standard SQL


 

Source: sqlite.org.