|
scoutsoft software development releases version 2.0 of xselect
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
company: scout-soft software development
|
| related press releases |
ezysoft developments released new invoice software : instant invoice n cashbook ™ 10 [2010-11-10 19:20:32] melbourne, vic oct 27th, 2010 -- ezysoft developments released instant invoice n cashbook ™ 10 (v10.6.1.1), a quick and simple windows based invoice software solution for the growing business. i... |
| outsystems speeds development and brings custom applications to the masses with agile platform 5.1 [2010-9-1 1:01:25] outsystems speeds development and brings custom applications to the masses with new agile platform
agile platform version 5.1 introduces new intelliwarp™ technology providing extreme producti... |
| with visual webgui 6.4 rc0 version, gizmox brings its vision of solving data-intensive ajax web development & deployment pains, to completion [2010-8-4 9:40:51] the new version is now available for download in free open source express format or in professional open source trial version.
since its inception in 2007, gizmox has been working towards the release... |
| autoplay media studio 8 brings visual software development to microsoft windows 7 [2010-7-21 8:33:20] (winnipeg) - indigo rose software announces the immediate availability of autoplay media studio 8 for windows. a mainstay in the software development industry for developing user-friendly autorun cd, ... |
| effectivesoft launches development for devices running ios 4 and updates iphone application development services. [2010-6-24 15:44:55] minsk, belarus – effectivesoft software firm announces the update of iphone development approach and offers application development services for revolutionary apple’s iphone 4. effectivesoft’s iphone ... |
| ensterminal suite was developed specially to increase comfort of work process development and testing. [2010-6-9 13:00:34] ensoftware terminal suite is an advanced terminal software (terminal emulator or communication program) for ms-windows, that allows programmers, engineers, testing teams and others groups to control, ... |
| webedesigner.com launches a $299 web design and development promotion [2009-11-26 16:20:34] new orleans, louisiana ( download3k ) october 16, 2009 - “with the introduction of our new $299 web design and development promotion we are able to give our clients an easy web design experience from ... |
| conaito technologies introduces the sip softphone activex - a powerful and highly versatile voip sdk to accelerate development of sip applications - release v1.0 [2009-10-14 21:36:50] software product: sip softphone activex - version 1.0
author: conaito technologies
sip softphone activex - a powerful and highly versatile voip sdk to accelerate development of sip applications.
... |
| epam systems becomes the sole ito provider with development centers in central and eastern europe ranked among “2009 top 50 best managed outsourcing vendors” [2009-9-7 12:25:44] newtown, pa — september 2, 2009 — epam systems, inc., the leading software engineering and it outsourcing (ito) provider in central and eastern europe (cee), has been recognized with yet another globa... |
| sftp protocol support for delphi application development [2009-7-27 9:46:37] devart releases new version of securebridge, a library of components for delphi, delphi for .net, and c++builder designed to protect connections between computers and trusted networks against unauthor... |
|
|
|
| vuze | azureus is a java based bittorrent client that offers multiple torrent downloads, queuing/priority systems (on torrents and files), start/stop seeding options and instant access to numerous pieces of information about yo |
|
| j. river media center | organize and experience all your media -- music, photos, and video your way - all from a single software program!
connect your pc to your home entertainment hardware and control it all with a remote! load your music |
|
| process lasso | process lasso is a unique new technology that will, amongst other things, improve your pc's responsiveness and stability. windows, by design, allows programs to monopolize your cpu without restraint - leading to freezes |
|
| goodsync | goodsync uses an innovative synchronization algorithm to synchronize your data between desktop pcs, usb drives, laptops and more.
goodsync combines bulletproof reliability with an extremely easy-to-use interface.
|
|
| jarte | jarte is a powerful, free word processor and wordpad replacement with a unique interface.
features include rtf and doc support, ole support, visual header & footer designer, clip history, online reference bar, tabbed |
|
| hypersnap-dx | hypersnap is the fastest and easiest way to take screen captures from windows screen, and text capture (textsnap) from places where normal text copy is not possible. hypersnap combines the power of a first-class screen c |
|
| aquasnap | the aquasnap application was developed to enhance the way you can arrange windows on your desktop. it gives you the possibility to snap windows to the edges or to the corners of the desktop simply by dragging and droppin |
|
| getdataback for ntfs | getdataback will recover your data if the hard drive's partition table, boot record, fat/mtf or root directory are lost or damaged, data was lost due to a virus attack, the drive was formatted, fdisk has been run, a powe |
|
|