xSelect
Before you Download
Run a FREE scan for Windows errors
Run a FREE scan for Windows errors
xSelect 2.0 release notes
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 using SQL
|
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 2009-10-10 |
Featured downloads
Download Free trial
Interact
Now downloading
Dirk Dashing
Save the world from the forces of E.V.I.L. in this action-packed adventure!
As agent Dirk Dashing...
Save the world from the forces of E.V.I.L. in this action-packed adventure!
As agent Dirk Dashing...