Below is the script I'm using
#!/bin/bash
export IFS=","
cat ddd.csv
I need to get the contents of ddd.csv as an array. I also need to convert that array in the form of a table with headers.
Please help,I'm really new to unix shell.
-
2Can you give us an example of the input, and exactly what you hope to do with it? Do you want an array where each item is one line of the CSV, or are you looking to read in multiple arrays, where each row from the CSV is returned as a single array? Or something else?larsks– larsks2015-06-03 13:09:16 +00:00Commented Jun 3, 2015 at 13:09
-
I need to compare the values of the mysql database with that of the csv array.How will i accomplish that?Adrian Veidt– Adrian Veidt2015-06-03 13:16:00 +00:00Commented Jun 3, 2015 at 13:16
-
Example of the input -> header1,header2,header3, content1, content2, content3, content1, content2, content3, content1, content2, content3Adrian Veidt– Adrian Veidt2015-06-03 13:19:22 +00:00Commented Jun 3, 2015 at 13:19
-
2When someone asks for additional information it is best to update your question rather than posting a comment (because the options for formatting things are much richer in the question). For example, your comment appears to show a single row, but from the names you have used I am guessing it actually represents multiple rows.larsks– larsks2015-06-03 13:21:32 +00:00Commented Jun 3, 2015 at 13:21
-
See stackoverflow.com/questions/22290809/…NaN– NaN2015-06-03 13:30:45 +00:00Commented Jun 3, 2015 at 13:30
|
Show 1 more comment
1 Answer
This page shows some tricks on how to extract CSV data in bash as below:
#!/bin/bash
while IFS="," read f1 f2 f3
do
echo $f1 $f2 $f3
done < ddd.csv
This should give you a table like output. Alternatively you can put the fields into an array or do whatever you like with them.
