2
votes
1answer
56 views

grep the string lines from the file

csv file. 1,2,3,abc 2,3,4,def 3,4,5,abc 3,4,2,def 6,7,9,abc. I need to read that file and get the lines of file containing abc.
1
vote
4answers
178 views

How to split CSV files as per number of rows specified?

I've CSV file (around 10,000 rows ; each row having 300 columns) stored on LINUX server. I want to break this CSV file into 500 CSV files of 20 records each. (Each having same CSV header as present in ...
0
votes
3answers
328 views

Unix - Surround First Column of CSV with double quotes

I have data in the following format - 4,"abc" 8,"def" 9,"ghi" I want to surround the value of the first column by double quotes. "4","abc" "8","def" "9","ghi" How do I do that ?
0
votes
1answer
222 views

AWK CSV stream editing, merge third columns for identical first columns when second column >= 0

I'm on Windows and have only heard of linuxes awk etc so I can only imagine that this is possible without actual scripting: I have data like .. 162 42 A single serving 162 62 of ...
1
vote
3answers
751 views

csv averages on linux command line

Hey I have a big file full of records like this 1, 2, 4, 5, 6 1, 3, 5, 6, 3 1, 4, 5, 6, 6 2, 4, 5, 5, 5 2, 3, 4, 5, 2 anyway i need to take the average of all rows with the same 1st number(key). ...