Hello, long time listener, first time caller here. I am trying to insert records into a db via a data file. Some of the records contain newlines represented by
\n that I need to be preserved in the db. I am using prepared statements, so I need the record with
\n to be sent as a double-quoted string to get the desired results. The problem is that
split strings behave like a single-quoted string (I'm not sure if that's the correct terminology). For example, if I hard code the following in my script it works fine:
@data = (1, 9999, "Here comes \n a new line");
$dbh->execute(@data);
Query results:
Here comes
a new line
But if I have a data file with
1|9999|Here comes \n a new line and then read that data file in such as:
while (<FH>) {
@arr = split /\|/;
$dbh->execute(@arr);
}
Query results:
Here comes \n a new line
I need the same behavior that I get with the hard-coded string when reading from a data file.
Thanks for any help you can offer!