Saturday 13 October 2012

Quick Code Generator

Sometimes you want to generate a quick bit of code and dont want to use a massive code generator. Well what if you could just get a list of values and apply a template to them quickly and generate the resulting code. The answer is http://nimbletext.com/live
I need to insert a few values from Excel into a SQL Database. The template looks like below Insert ADX.tbl_PROD_ADVERTISER_Mapping( ADVERTISER_ID, ADVERTISER_NAME_SB, REVENUE_STREAM, ADVERTISER_NAME_ADX) Values ($0, '$1', '$2', '$3') go To split on tabs (defualt when copying from Excel) use \t as the column separator.