Thanks Patrick. That is more in line with what I'm used to seeing. I hadn't seen the `read -r...` before but it seemed to be coming up all over the intertubes. And if I've understood correctly, I'm going to have to use the read command as cat messes with line breaks in some weird way (some day, when this is all over, I'll write a book on bash and white space and I'll name it "Into the Void"…)
Thanks again, Ted On Tue, Jan 22, 2019 at 11:41 PM Patrick Woolsey <[email protected]> wrote: > Though this isn't especially my bailiwick :-) I believe you may > need to make a couple of adjustments. > > First, this is the heredoc variable assignment form I'm familiar with: > > ======== > SQL=$(cat <<-EOF > INSERT INTO mytable > (\`field1\`, \`field2\`) > VALUES > ('val1', 'val2') > EOF > ) > > echo "$SQL" > ======== > > Next, you'll need to change "SQL" on line 6 to "EOF" (so the > heredoc start & end delimiters match), and also escape the > backticks on line 3 to keep the shell from trying to interpret > them, and I believe that should do the job. :-) > > > Regards, > > Patrick Woolsey > == > Bare Bones Software, Inc. <http://www.barebones.com/> > > > > On 1/22/19 at 5:01 PM, [email protected] (Gustave > Stresen-Reuter) wrote: > > >Hi, > > > >I'm trying to test a heredoc in a worksheet but I can't quite work out the > >syntax. > > > >All of the examples I've seen look like this: > > > >cat << EOF > SQL > >INSERT INTO mytable > >(`field1`, `field2`) > >VALUES > >('val1', 'val2') > >SQL > > > >echo "$SQL" > > > >But when I try that in a worksheet, the echo is a blank line. > > > >What am I doing wrong? > > > >Thanks in advance. > > > >Ted Stresen-Reuter > > > > -- > This is the BBEdit Talk public discussion group. If you have a > feature request or need technical support, please email > "[email protected]" rather than posting to the group. > Follow @bbedit on Twitter: <https://www.twitter.com/bbedit> > --- > You received this message because you are subscribed to the Google Groups > "BBEdit Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/bbedit. > -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting to the group. Follow @bbedit on Twitter: <https://www.twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/bbedit.
