Previous
TOMSK, Russian Federation (October, 15th, 2009) - Scoutsoft Software Development Releases version 2.
Added: (Thu Oct 22 2009)
TOMSK, Russian Federation (October, 15th, 2009) - Scoutsoft Software Development releases version 2.0 of xSELECT
xSELECT is a command-line utility that allows you to search textfiles.
But unlike tools like "grep" or "find", xSELECT allows you to use a SQL-query statement for analyzing textfiles incl. filtering, sorting, ordering and grouping.
• SQL Select
• SQL Distinct
• SQL Where
• SQL And & Or, <> =, LIKE
• SQL Order By
Using standard SQL-queries you can filter the content of a textfile or use standard SQL-aggregate functions to calculate sums, averages etc. :
• AVG() - Returns the average value
• COUNT() - Returns the number of rows
• MAX() - Returns the largest value
• MIN() - Returns the smallest value
• SUM() - Returns the sum
Example:
Let's say that you have a textfile - for example a file called "customers.csv" - which you want to filter and sort for some criteria using a SQL query :
Customers.csv :
===============
Name,City,ZIP,Orderdate,amount
Miller,New York,1234,150.00
Smith,Washington,4321,200.00
Brown,New York,1234,300.00
Using xSELECT you can run SQL queries like this:
xSelect * from Customers.csv where ZIP="1234"
xSelect Name, sum(amount) as Total from Customers group by Name order by Total desc
xSelect Name,City from customers.csv order by name
Compatibility:
xSELECT will run under Windows only and has been tested under Windows 2000\2003\2008 Server and Windows 2000 Pro\Vista
xSELECT is a standalone application and is non-dependent on any other windows-components like .NET or dataproviders\drivers like ODBC/ADO etc.
Pricing / License:
* With a Home License, you are allowed to use xSelect on 1 PC for non-commercial purposes in non-business, non commercial environment. The Home Licence will not run under Windows Server Editions like Windows 2003 Server etc. but only under Win2000 Pro, XP, Vista, Windows2007.
Home Licence: 19 Euro
* Only with a Business License, you are allowed to use xSelect on 1 PC in a corporate, government or business\commercial environment.
The Business License does support all Windows editions up to Windows Server 2008 and is valid only for the installation on 1 PC\Server (1 Windows instance) - Volume Licences are available upon request - please contact info@Scout-Soft.com
Business Licence: 69 Euro
Contact:
E-Mail : info@Scout-Soft.com
Site : http://www.scout-soft.com/xselect