foreach ( @lines_from_text_file )
{
    chomp ;
    my @fields = split /,/ ;
    printf( "insert into my_table values\n" .
            "( %s, %s, %s, %s, %s, %s )\n",
            @fields
          ) ;
}