Textselect
Description:
"textselect" is a command line program that allows you to combine text files containing columns of data with a sql like syntax.
The specific use case this was written for was in order to combine various outputs from network equipment - for instance, pulling the MAC address and switchport from a Cisco switch's "show mac address-table" command, pulling the the ip address and mac address from a Cisco firewall's "show arp" command, pasting these outputs into separate text files, then using textselect to coorelate ip addresses and switchports based on the shared mac address.
Sample syntax:
./textselect a.txt.1, a.txt.3, m.txt.4, c.txt.5 from a.txt m.txt c.txt where a.txt.3 == m.txt.2 and a.txt.2 in c.txt.5 options inner
- The "fields" you select are in the format of filename.X where X is the column number, starting with 1
- The "tables" you are pulling from are the filenames themselves
- The "where" clause currently only supports ==, in, and and.
- The only option currently implemented is "inner" which switches up to an "inner" type join rather than the default "outer" join.
License:
GPLv3
Download:
Listing directory https://download.elifulkerson.com/files/textselect/0.1:textselect June 21 2019 16:20:26 10293 Python script, ASCII text executable
textselect.asc July 03 2019 15:32:26 801 GnuPG signature
textselect.md5 July 03 2019 15:32:26 45 MD5 checksum
