February 20, 2011

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

For example you found some nice Google Docs Sheet


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


also you may like to switch into edit mode (if you have enought rights). Just replace "pub" with "ccc"

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 16, 2011

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.