3
votes
1answer
591 views

Unix command to get number of lines in a CSV file

I have to get the count of lines from incoming CSV files. I have used the following command to get the count. wc -l filename.csv Consider files coming with 1 record I am getting some files with * ...
0
votes
1answer
334 views

Using Command Prompt to create Retina Vulnerability Report CSV

I have scanned several computers on my network which have been flagged as needing certain fixes. I am able to generate reports in Retina fine using the GUI report view, however, I would like to be ...
-3
votes
1answer
254 views

Deleting the first column of csv via batch commands [duplicate]

Is there a way to delete the first column of a csv using a batch command file? I have data in this first column but I want to get rid of it and output a new file starting at the 2nd column. Thanks!
0
votes
2answers
1k views

How a batch file overwrite contents of output each time?

Basically I have this batch file below, which will return the first x rows from the input .csv file parameter. However, the only issue now is that this batch file will be called several times to ...
1
vote
4answers
3k views

Can I use a batch file to remove blank columns in a .csv

I have nine columns in my current .csv file, however, the 2nd and 3rd columns are blank and I want to get rid of them. Is there a way to use batch commands to remove these empty columns from my .csv ...
0
votes
1answer
518 views

Export the first three rows of a .csv into another .csv using batch commands

I have a .csv file with a number of rows but I only want the first three rows and none of the rest. How can I use a batch file to export those top 3 rows of my .csv file into another file .csv file? I ...
3
votes
1answer
215 views

CLI program for xlxs -> csv conversion?

Is there an foss command line program that can convert between Excel (.XLXS) and Comma Separated Value (.CSV) files?
3
votes
1answer
855 views

Interactive console based CSV editor

Although spreadsheet applications for editing CSV files on the console used to be one of the earliest killer applications for personal computers, only few of them and even less documentation about ...
6
votes
4answers
5k views

Unix command-Line CSV viewer

Is there a convenient command-line csv viewer, possibly a unix tool or a mod of some tools (e.g. vim or python)? I find it easy to simply edit CSV files by writing it manually (since all you need to ...