>One of my biggest moments was figuring out you could run SQL from the command line, using environment variables in the query string. Ha ha, nice. You can do

>One of my biggest moments was figuring out you could run SQL from the command line, using environment variables in the query string. Ha ha, nice. You can do something similar to that with awk. The classic book titled The Unix Programming Environment, by Kernighan and Pike, has some good examples of that. https://en.m.wikipedia.org/wiki/The_Unix_Programming_Environment https://en.m.wikipedia.org/wiki/The_Unix_Programming_Environ... You have to quote and unquote parts of the awk command appropriately, so that some parts of the command are processed directly by awk, and others by the shell (first).