Table To Json
Convert text tables to a json document.
Usage
$ ./convert_to_json.py (index=[name],...) (file,...) --delim=delim[:min[-max]],...
-
index: the table column index to print, begins from 0. Can be combined with '=' to define a name for this index. If equal to '*', all indexes will be accepted (you can combine '*' with regular indexes).
-
file: one or more file names to read from. The default is stdin.
-
delim: One or more string delimiter of the table seperated by comma (,). Can be combined be ':' and a minimum delimiter repeat count, and (optional) '-' and maximum delimiter repeat count. The default minimum number is 1, the default maximum number is infinite.
Examples
Parse a CSV file:
$ ./convert_to_json.py '0=Name,1=UserName,3=Phone' Data/names.csv --delim='\,'
[{"Phone": "1234", "UserName": "Jim1", "Name": "Jimmy"}, {"Phone": "0000", "UserName": "TheHacker^", "Name": "John"}, {"Phone": "1111", "UserName": "r00x", "Name": "Jack"}]
Parse the linux ss command output and get the currently open tcp sessions:
$ ss --tcp | ./convert_to_json.py '0=State,3=LocalAddressPort,4=RemoteAddrPort'
[{"State": "ESTAB", "LocalAddressPort": "10.0.0.2:42554", "RemoteAddrPort": "x.x.x.x:https"}]