in shell script,how to read csv file line by line and get values

Question

i have csv file with three fields(length,height,width).i want to read these values line by line and update these values in database.how to read the file line by line and update these values in data base.

we can use "load In file" query to update entire file to db.but i want to update the modified values from csv to db.so how to read file line by line and update these values.?

The most obvious answer is don't do it in shell, do it in a language with a proper csv reading library. It'll be faster and less likely to break on interesting csv formats. — Douglas Leeder
– Douglas Leeder, Commented Jul 12, 2011 at 9:50

Jonathan Leffler · Accepted Answer · 2011-07-12 13:25:16Z

3

As Douglas said in a comment, using sh to parse CSV is a really non-scalable plan. If the input file is anything but trivial, it will not work. However, for trivial input, you just need to set IFS. Here's an example that reads and tries to put the data into a MySQL database (I didn't test the SQL...the syntax may be (probably is) off):

#!/bin/sh
IFS=,

while read one two three; do
    echo "insert into table( col1, col2, col3 ) "'
        '"values ('$one', '$two', '$three');"
done |
mysql db;

edited Jul 12, 2011 at 13:25

Jonathan Leffler

760k145 gold badges961 silver badges1.3k bronze badges

answered Jul 12, 2011 at 11:12

William Pursell

214k49 gold badges279 silver badges317 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jonathan Leffler Over a year ago

For numeric values (length, width, height), you probably don't need to quote the values in the VALUES list. However, the original discussion also mentioned 'update', but then you need a way to identify the row to be updated too, which is a nuisance since it is not clear that the file contains that information.

Collectives™ on Stack Overflow

in shell script,how to read csv file line by line and get values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related