read and post to MySQL

[FengShui1998]

Hello,

I'm familiar with VBscript but need a script for UNIX that reads a file. The first line has fifty fields and is comma delimited. Is there a split function that reads this line into an array.

I then need to do an INSERT into MySQL database. Your help is greatly appreciated.

fengshui1998

 

[PHV]

man awk

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[feherke]

Hi

A [tt]bash[/tt] only way to spread comma ( , ) separated values across an array :

[blue]master #[/blue] line="zero,one,two,three,four"

[blue]master #[/blue] IFS=,

[blue]master #[/blue] array=($line)

[blue]master #[/blue] echo ${#array[*]}
5

[blue]master #[/blue] echo ${array[3]}
three

Feherke.

http://rootshell.be/~feherke/