Quick Tip: CSVFIX Skip First Line

Update Oct 2017 – For most csvfix commands the ‘-ifn’ command will also skip the first line. I say most as I know that it does not work for “read_dsv” which is ok as long as you are not combining files in addition of converting to CSV. The below solution is also good if you’re getting output that has an extended header. I have one source where the first 6 lines lists out how the report is created out of SAP.

Got headers that you don’t want? Want to skip that first line and the 1.6 manual does not elude to how? Let me cut to the chase:

  • csvfix remove -if “$line == 1” input_file.csv > output_file.csv

This will skip the first line so that you can add your own headers.

Leave a Reply

Your email address will not be published. Required fields are marked *