Command Line Interface Tools plane - stands for perl with -lane switches. * Replaces awk - reads a file from standard input into @F variable. and allows easy filtering including regexp group matching. * Run without params to show numbers of fields in standard input. * You can access fields from end and grep using: plane 'print @F[-1] if @F[0] =~ /^192.168.0.1/' * You can print multiple fields: plane 'print join("\t",@F[0..2,-1])' csv2xlsx.py - convert CSV to XLSX * Requirements: sudo easy_install openpyxl tzcovert - convert filter from Zulu to local time echo "2017-04-02T23:53:32.000Z" | tzconvert # returns: 2017-04-03T01:53:32