Differences

This shows you the differences between two versions of the page.

--- pretty_print_csv_data [2021/07/02 19:12] – created admin
+++ pretty_print_csv_data [2023/11/27 05:59] (current) – [bash function] raju
@@ Line 1: / Line 1: @@
-==== bare bones solution ====
+==== command line ====
 <code>
  | column -t -s,
@@ Line 46: / Line 46: @@
 See also:- https://www.stefaanlippens.net/pretty-csv.html - talks about handling corner cases and other OSes.
+==== zsh function ====
+(Todo, 2023-11-27): Add instructions to do this in zsh shell
+==== vim ====
+To convert the whole file
+<code>
+:%!column -t
+</code>
+To convert a visual selection
+<code>
+:'<,'>!column -t
+</code>
+Sample input:
+<code>
+.33570301776, 3.61194e-06, 7.24503e-06, -9.91572e-06, 1.25098e-05, 0.0102828
+.34538754675, 3.3689e-06, 9.86066e-06, -9.12075e-06, 1.18058e-05, 0.00334344
+.34808186291, -1.99011e-06, 6.53026e-06, -1.18909e-05, 9.52337e-06, 0.00158065
+</code>
+Sample output:
+<code>
+.33570301776,  3.61194e-06,   7.24503e-06,  -9.91572e-06,  1.25098e-05,  0.0102828
+.34538754675,  3.3689e-06,    9.86066e-06,  -9.12075e-06,  1.18058e-05,  0.00334344
+.34808186291,  -1.99011e-06,  6.53026e-06,  -1.18909e-05,  9.52337e-06,  0.00158065
+</code>
+Ref:- https://stackoverflow.com/questions/1229900/reformat-in-vim-for-a-nice-column-layout - contains some tips on how to handle cases where there are delimiters inside string literals.