Run sql-like command on files from terminal # download: # https://github.com/harelba/q # example: q -d "," "select c3,c4,c5 from /path/to/file.txt where c3='foo' and c5='boo'"
ssh user@remote 'find . -maxdepth 2 -type f' | sort | sed "s@.*@ mkdir -p \"\`dirname '\0'\`\"; touch '\0' @" | sh
ssh user@remote 'find . -maxdepth 2 -type f' | sort | sed "s@.*@ mkdir -p \"\`dirname '\0'\`\"; touch '\0' @" >test.txt vim test.txt sh <test.txt