Linked Questions

Ask Question
18 questions linked to/from Is there a robust command line tool for processing CSV files?
Hot Newest Score Active Unanswered
4 votes
6 answers
25k views

I have a comma-separated file which has numeric and string columns. String columns are quoted and can have comma in between the quotes. How do I identify the columns with FS =","? Sample records "...
prabhat diwaker's user avatar
  • 41
3 votes
1 answer
12k views

I'm currently working with some CSV datasets and was wondering whether there are any good (even better if standard) CLI ways of manipulating CSV data. To be more precise, I mainly want to be able to: ...
nikitautiu's user avatar
  • 1,329
4 votes
2 answers
4k views

Possible Duplicate: Is there a robust command line tool for processing csv files? I can use cut to extract columns from a file: $ cat foo foo,bar,hello bash,baz,world $ cut -d\, -f2 foo bar baz ...
Cory Klein's user avatar
  • 19.4k
0 votes
3 answers
2k views

I'm using bash shell. I want to parse a CSV file, in which the CSV file observes true CSV formats. From this thread -- https://stackoverflow.com/questions/4286469/how-to-parse-a-csv-file-in-bash , I ...
Dave's user avatar
  • 2,808
3 votes
1 answer
1k views

Possible Duplicate: Is there a robust command line tool for processing csv files? I am trying to parse the second line in a file (which contains commas within double quotes) "100 Watt A19 10,000 ...
Etienne Lawlor's user avatar
  • 135
1 vote
2 answers
2k views

I have a file in which the fields are separated by comma. Some example input: col1,"1,2",col3 col1,"1,2,3",col3 col1,"1 2,3",col3 col1,"1 "2,3"",col3 Now, I have to fetch the second column, so that ...
gus's user avatar
  • 11
43 votes
5 answers
61k views

Having a file of the following contents: 1111,2222,3333,4444 aaaa,bbbb,cccc,dddd I seek to get a file equal to the original but lacking a n-th column like, for n = 2 (or may it be 3) 1111,2222,4444 ...
Ivan's user avatar
  • 18.4k
28 votes
5 answers
82k views

How can I do the following to a CSV file using sed or awk? Delete a column Duplicate a column Move a column I have a big table with over 200 rows, and I'm not that familiar with sed.
Binoy Babu's user avatar
  • 1,065
9 votes
3 answers
9k views

I have a CSV file like: Name,Age,Address Daniel Dvorkin,28,Some Address St. 1234 (... N ...) Foo Bar,90,Other Address Av. 3210 And I have a command that take this parameters: ./mycommand --name="...
MZAweb's user avatar
  • 563
4 votes
3 answers
39k views

I have been give a command which outputs a comma-separated list for autosys jobs in the variable $all_jobs: box=box-of-jobs;all_jobs=$(jobscout -box $box | egrep "^\w+" | tr '\n' ',' | sed s/.$//); ...
Ian's user avatar
  • 53
10 votes
1 answer
3k views

How would you modify function csv_to_sqlite so that sqlite3 command .import reads directly from standard input instead of from a temporary named pipe? #!/bin/bash function csv_to_sqlite() { local ...
Derek Mahar's user avatar
  • 567
2 votes
3 answers
2k views

I have a CSV file of approx 1000 rows, and where I'm supposed to import it, I get an error on row 700. However, the entries in this CSV contain newlines (and are quoted), and thus I cannot really ...
sdbbs's user avatar
  • 590
1 vote
3 answers
2k views

I have multiple CSV files with many records. The total number of rows should be 134. I have many files, and each rows has its own number of columns (from 15 to 200). I need to sort them according to ...
Hussein Kray's user avatar
  • 21
1 vote
2 answers
2k views

I am sorry if my question is more a typographical error, but I have been trying to sort this out for a while now and sadly, I cannot get this to work. Perhaps I should use the sed command, but I haven'...
Jesse's user avatar
  • 25
0 votes
1 answer
615 views

I have a comma separated string that could contain quoted elements with commas. For example: issuer=C = US, O = "DigiCert, Inc.", CN = DigiCert High Assurance TLS Hybrid ECC SHA256 2020 CA1 ...
Matteo's user avatar
  • 10.1k

15 30 50 per page
1
2