Shell script that parses a CSV file, builds sql insert calls, then executes them - dBforums

rowcount = 0 cat $CSV_DIR/$1 | while read fileline do rowarray[i] = $fileline rowcount = $rowcount + 1 done i = 0 query = "" while [ "$i" -le "$rowcount" ] do n = split(${rowarray[$i]}, colarray, ",") if [ "$n" -ge "2" ] then query = $query + "\n" + "

www.dbforums.com