Mark Sta Ana booyaa

#zero padding strings

source: http://stackoverflow.com/a/10841820/105282

you want single digits to be zero padded.

("00"+1).substr(-2)  // 01
("00"+11).substr(-2) // 11

#ERROR redirection

:: redirect stderr to nul
dir *.csv 2> NUL

:: in a batch file for loop, you may need to escape the char
for /f "delims=" %%x in ('dir *.csv 2^> NUL') do @echo %xx

Convert DataTable into a Dictionary

let's assume your dt looks like

|key |value|
|----------|
|your|mum  |

#split string into an array of strings

source: http://stackoverflow.com/a/3008775/105282

namespace StringChunks
{
    static class Tools
    {
        public static IEnumerable<string> SplitByLength(this string str, int maxLength)

Don't forget to add the following referencs to your query if using LINQPad:

System.Collections
System.Data.OleDb
System.Data.SqlClient
System.Xml
System.Xml.XPath

	/*
	Assume you have a value in a table that looks like this:

	select foo from bar

	\|foo \|
	\|uspFTW 123\|

	You want to change 123 to 929
	*/

	/*
	Colchester HackSpace (@ColchHackSpace) HAXMAS!!!


	heavily based on blink
	tunes provided by https://gist.github.com/elubow/7844436

	/This/ example code is in the public domain.

	Power to v3.3

	ECHO OFF
	::everyone loves metrics!
	ECHO Start: %TIME%

	ECHO Copying common config files
	::testing if config file has ever been copied to release folder
	IF NOT EXIST "$(TargetDir)settings.cfg" GOTO copyFile

	::testing if config file has been updated
	FC "$(ProjectDir)\settings.cfg" "$(TargetDir)settings.cfg" \| FIND "FC: no dif" > NUL

	grep -iE '(robonaut\|jonty\|russs)' -hack-space.12.log \| grep -i votes \| grep -i '@russs'

	#london-hack-space.12-06.log:10:57 <@russss> 3 votes so far :/
	#london-hack-space.12-06.log:10:58 <@russss> we need 183 votes to be quorate. Might be a tough one
	#london-hack-space.12-06.log:11:07 <@russss> 16 votes
	#london-hack-space.12-06.log:11:42 <@russss> we've got 50 votes now
	#london-hack-space.12-06.log:13:04 <@russss> 73 votes
	#london-hack-space.12-06.log:16:10 <@russss> 93 votes so far
	#london-hack-space.12-06.log:18:16 <@russss> 103 votes
	#london-hack-space.12-06.log:18:57 <@russss> http://en.wikipedia.org/wiki/Counting_Single_Transferable_Votes