linux command to delete the last column of csv

Question

How can I write a linux command to delete the last column of tab-delimited csv?

Example input

aaa bbb ccc ddd
111 222 333 444

Expected output

aaa bbb ccc
111 222 333

Answer

It is easy to remove the fist field instead of the last. So we reverse the content, remove the first field, and then revers it again.

Here is an example for a “CSV”

rev file1 | cut -d "," -f 2- | rev

Replace the “file1” and the “,” with your file name and the delimiter accordingly.

Accepted Answer

It is easy to remove the fist field instead of the last. So we reverse the content, remove the first field, and then revers it again. Here is an example for a &#8220;CSV&#8221;rev file1 | cut -d "," -f 2- | revReplace the &#8220;file1&#8221; and the &#8220;,&#8221; with your file name and the delimiter accordingly.

Advertisement

Answer