Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Re^8: Query Does not work in Spreadsheet::WriteExcel

by AnomalousMonk (Bishop)
on Jul 25, 2020 at 02:39 UTC ( #11119785=note: print w/replies, xml ) Need Help??

in reply to Re^7: Query Does not work in Spreadsheet::WriteExcel
in thread Query Does not work in Spreadsheet::WriteExcel

How then did you generate the query string in Perl? Did you use a here-doc? Some variations of here-doc handle escapes (and interpolation).

I think the point choroba is making is that a double-quote string constructor processes escapes (and also interpolates):

c:\@Work\Perl\monks>perl -wMstrict -le "my $sq = '\Quick and \Easy \Upper \Limit \\UTTER \\LAUGH \Wow'; print qq{>$sq<}; " >\Quick and \Easy \Upper \Limit \UTTER \LAUGH \Wow< c:\@Work\Perl\monks>perl -wMstrict -le "my $dq = qq{\Quick and \Easy \Upper \Limit \\UTTER \\LAUGH \Wow}; print qq{>$dq<}; " Unrecognized escape \W passed through at -e line 1. >uick\ and\ asy PPER imit \utter \laugh wow<
(Do you have warnings enabled?)

Give a man a fish:  <%-{-{-{-<

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11119785]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2020-09-27 00:46 GMT
Find Nodes?
    Voting Booth?
    If at first I donít succeed, I Ö

    Results (142 votes). Check out past polls.