in reply to Extract Elements from an array and insert into database

Here are the things you'll need to read in order to solve your problem:

Text::CSV_XS - read about this module and the sep_char option. Use parse and fields methods to parse the data

DBI - Then use prepare and Placeholders to insert your data.

grep

In Section Seekers of Perl Wisdom