View tabular file such as CSV from command line [closed]

by

You can also use this:

column -s, -t < somefile.csv | less -#2 -N -S

column is a standard unix program that is very convenient — it finds the appropriate width of each column, and displays the text as a nicely formatted table.

Note: whenever you have empty fields, you need to put some kind of placeholder in it, otherwise the column gets merged with following columns. The following example demonstrates how to use sed to insert a placeholder:

$ cat data.csv
1,2,3,4,5
1,,,,5
$ sed 's/,,/, ,/g;s/,,/, ,/g' data.csv | column -s, -t
1  2  3  4  5
1           5
$ cat data.csv
1,2,3,4,5
1,,,,5
$ column -s, -t < data.csv
1  2  3  4  5
1  5
$ sed 's/,,/, ,/g;s/,,/, ,/g' data.csv | column -s, -t
1  2  3  4  5
1           5

Note that the substitution of ,, for , , is done twice. If you do it only once, 1,,,4 will become 1, ,,4 since the second comma is matched already.

More Related Contents:

  1. How can I use xargs to copy files that have spaces and quotes in their names?
  2. How to change the output color of echo in Linux
  3. sed in-place flag that works both on Mac (BSD) and Linux
  4. How can I search for a multiline pattern in a file?
  5. Peak memory usage of a linux/unix process [closed]
  6. Pipe to/from the clipboard in a Bash script
  7. Find and replace with sed in directory and sub directories
  8. Uninstall Node.JS using Linux command line?
  9. Get most recent file in a directory on Linux
  10. Sorting a tab delimited file
  11. Using curl to send email
  12. How to count lines in a document? [closed]
  13. How to create a file with a given size in Linux?
  14. How to run a shell script on a Unix console or Mac terminal?
  15. Perl command line multi-line replace
  16. How do I include a pipe | in my linux find -exec command?
  17. A way to determine a process’s “real” memory usage, i.e. private dirty RSS?
  18. Linux command to list all available commands and aliases
  19. extracting unique values between 2 sets/files
  20. Is there a way to get gcc to output raw binary?
  21. Execute command after every command in bash
  22. Execute combine multiple Linux commands in one line
  23. Is there a way to make mv create the directory to be moved to if it doesn’t exist?
  24. Should I use libc++ or libstdc++? [closed]
  25. How can I get the resolution (width and height) for a video file from a linux command line?
  26. Why no output is shown when using grep twice?
  27. What is PATH on a Mac (UNIX) system?
  28. Find all files with name containing string [closed]
  29. How do you run a script on login in *nix?
  30. Search and replace with sed when dots and underscores are present

Leave a Comment