Friday, July 22, 2016

Simple Quick Text Processor for SQL data analysts

This post aims to introduce a simple application that can help people who work with SQL server management studio or MySQL workbench to quickly process/transpose column of values into a row of comma separated values which you can then include back in your queries. Most people I  know who work with workbench or SQL server normally copy the column values to excel, transpose the values and then copy the values into notepad for formatting, and then include the values into their queries.

Quick text processor eliminates all the above process in that you can copy and paste into it and it will reformat the text in comma, space or apostrophes. Additionally you can remove duplicates from a list of values or compare two columns of values to get the values that are in one of the columns but not the other.  

Download Quick Text from here 
View the source code from here