Video Site:: Sort CSV by Column

### Overview This presentation offers a quick tutorial on how to sort comma-separated value (CSV) files by specific columns using command-line tools in Bash. The speaker explains what CSV files are and highlights how the standard Linux `sort` command can be configured to target specific delimited fields rather than sorting solely from the beginning of each line.

### Key Topics - **Understanding CSV Files**: Explanation of CSV files as plain text files where data is delimited by specific characters, most commonly commas. - **Default Behavior of the `sort` Command**: Review of how standard `sort` processes files alphabetically across entire lines from the very first character. - **Custom Delimiters and Key Fields**: Using command-line flags to specify field delimiters and select specific target columns for alphabetical ordering. - **Non-Destructive File Display**: Understanding that sorting commands print modified views to stdout without altering the underlying source files. - **Output Redirection**: Writing sorted results to new CSV files using shell redirection.

### Technical Details The demonstration uses a sample plain-text CSV file containing three columns: a first name, a last name, and a state of origin.

1. **Inspecting the File**: The file is first inspected using `cat` to display its original contents and initial ordering. 2. **Default Sorting**: Running `sort` on the file sorts it alphabetically by the first column (the entire line starting from first name). 3. **Sorting by a Specific Field**: - `-t <delimiter>`: Specifies the field separator or delimiter. In this demonstration, a comma is supplied (`-t ,`). - `-k <number>`: Designates the key column/field to sort on. Specifying `-k 2` sorts the output alphabetically by the second column (the last name), while `-k 3` sorts by the third column (the state). 4. **Data Persistence**: The speaker emphasizes that sorting commands only affect output display and do not overwrite or modify the original file. To preserve the sorted data, shell redirection is used to write the sorted stream into a new file (e.g., `new.csv`).

### Takeaways The `sort` command in Linux provides a simple and efficient way to manipulate tabular text data directly from the terminal without specialized software. By pairing the `-t` delimiter flag with the `-k` field flag, users can quickly sort CSV records by any column and optionally redirect the sorted output into new files. Note that while this video was presented as a general terminal and Bash tip on filmsbychris.com, it contains no explicit discussion of cybersecurity, vulnerabilities, or exploits.