Re: REGEXP_LIKE W/DBI

Perhaps you need to double up on the backslashes?

my $like = "REGEXP_LIKE(note_tx, 'CA\\s+\\n?Merged\\s+\\n?From:\\s+\\n
+?Vendor:')";
[download]

Comment on Re: REGEXP_LIKE W/DBI Download Code

Replies are listed 'Best First'.
Re^2: REGEXP_LIKE W/DBI by AnomalousMonk (Archbishop) on May 30, 2014 at 01:48 UTC
Or even single down on the quotes: `c:\@Work\Perl\monks>perl -wMstrict -le "my $like = q{REGEXP_LIKE(note_tx, 'CA\s+\n?Merged\s+\n?From:\s+\n?Ven +dor:')}; print qq{:$like:}; " :REGEXP_LIKE(note_tx, 'CA\s+\n?Merged\s+\n?From:\s+\n?Vendor:'):` [download] BTW: `\s` includes `\n` so `\s+\n?` is redundant; might as well just be `\s+`	[reply] [d/l] [select]
Re^2: REGEXP_LIKE W/DBI by dirtdog (Monk) on May 30, 2014 at 12:49 UTC
Sorry for the late response, but i had to leave unexpectedly yesterday shortly after posting my question. "Doubling up" on the backslashes solved the issue! Thanks again.	[reply]