A daily 311 export is a delimited text file with a category column. Analysts want a quick per-category ticket count on the jump host. Which tool is the best fit?
Select an answer to reveal the explanation.
Short Explanation
Think of awk as a pocket spreadsheet for text columns: point it at the category field and it tallies tickets. You can get a quick 311 count on the jump host without spinning up BI.
Full Explanation
A daily 311 export with delimited text and a category column is a straightforward text-processing workload. On a jump host, awk can split fields, group records by a column, and count them without requiring a BI platform. Grouping and counting the category field gives you a quick per-category ticket tally for operational spot checks and shell pipelines. A WYSIWYG slide editor that cannot read delimited columns cannot aggregate categories from the export; presentation tools are the wrong fit for column-based counting. An image gallery browser pointed at the export path displays images, not delimited fields, so it cannot analyze category frequency. A DNS lookup utility treats category labels as hostnames and looks them up rather than counting tickets; those labels are ticket taxonomy, not hostnames. Exam caveat: confirm whether the delimiter is a comma, tab, or pipe and whether a header row needs to be skipped, since awk field positions must match the schema. If quoted delimiters make the file complex, a CSV-aware tool may be needed, though the question’s straightforward text-counting task points to awk. Practical check: run awk on a sample export with known category frequencies, compare its totals against an independent count, verify header handling, and save the command as an alias or scheduled job so analysts can reproduce the tally after each daily export.