I added the following line after the "chomp":

$sometext =~ s/\'//g;
[download]

This removes the ' and allows the entry to be posted to the db/table. This is not ideal as I need quotations to be preserved. thank you