When you work with delimited data (CSV, TSV etc...) it can be a pain to just see the data in a nice way, for example, this data:
- > cat people-example.csv.txt
- First Name,Last Name,Country,age
- "Bob","Smith","United States",24
- "Alice","Williams","Canada",23
- "Malcolm","Jone","England",22
- "Felix","Brown","USA",23
- "Alex","Cooper","Poland",23
- "Tod","Campbell","United States",22
- "Derek","Ward","Switzerland",25
With Unix like OSs, you can use the column command to format the layout; for example:
- > column -t -s',' people-example.csv.txt
- First Name Last Name Country age
- "Bob" "Smith" "United States" 24
- "Alice" "Williams" "Canada" 23
- "Malcolm" "Jone" "England" 22
- "Felix" "Brown" "USA" 23
- "Alex" "Cooper" "Poland" 23
- "Tod" "Campbell" "United States" 22
- "Derek" "Ward" "Switzerland" 25
With Windows, you can use Import-CSV and Format-Table in PowerShell:
- > Import-Csv .\people-example.csv.txt | Format-Table
- First Name Last Name Country age
- ---------- --------- ------- ---
- Bob Smith United States 24
- Alice Williams Canada 23
- Malcolm Jone England 22
- Felix Brown USA 23
- Alex Cooper Poland 23
- Tod Campbell United States 22
- Derek Ward Switzerland 25