txtselect 1.0

txtselect was developed as Python-based tool that applies a simple SQL query (without joins) to a tab-separated-value text file. The application features a simple Command-Line interface. The software can be used if, for example, you want to determine the total population for each U.S. state, and you have a file where each line has a county name, the state name, and county population, separated by tabs. · Supported operators: ** * / % + – = == != = not and or · Supported aggregate functions: count, sum, avg, min, max, first, last · Supported scalar functions: abs, bin, ceiling, concat, concat_ws, floor, hex, if, instr, left, length, lower, lpad, ltrim, oct, ord, right, round, rpad, rtrim, space, substr, trim, upper