Differences

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

--- apply_unix_commands_to_all_but_the_first_line [2022/08/12 13:39] – [Practical solution] raju
+++ apply_unix_commands_to_all_but_the_first_line [2022/08/12 16:44] – [How I came across it] raju
@@ Line 129: / Line 129: @@
 ==== How I came across it ====
-I came across it while reading the book "Data Science at the Command Line" (2nd Edition) by Jeroen Janssens (https://smile.amazon.com/Data-Science-Command-Line-Explore/dp/1492087912). The book is available for free at https://datascienceatthecommandline.com/2e/ . The 'body' and 'header' commands are discussed in https://datascienceatthecommandline.com/2e/chapter-5-scrubbing-data.html#bodies-and-headers-and-columns-oh-my .
+The 'body' and 'header' commands are discussed in the book "Data Science at the Command Line" (2nd Edition) by Jeroen Janssens (https://smile.amazon.com/Data-Science-Command-Line-Explore/dp/1492087912). It is available for free at https://datascienceatthecommandline.com/2e/ . See for example https://datascienceatthecommandline.com/2e/chapter-5-scrubbing-data.html#bodies-and-headers-and-columns-oh-my .
+==== Close but no cigar ====
+Here I will try to list some alternative approaches that are close but not perfect.
+Solution 1:
+<code>
+$ cat input.txt
+value
+
+
+
+
+$ (head -n 1 input.txt; tail -n +2 input.txt | sort)
+value
+
+
+
+
+</code>
+Disadvantages:
+  * Requires two passes on the input (once to extract the header and another to process the body)
+  * Does not work if the input is coming from stdin