Is there an easy way to run a MySQL query from the Linux command line and output the results in [CSV][1] format?

Here&#39;s what I&#39;m doing now:

```lang-none
mysql -u uid -ppwd -D dbname &lt;&lt; EOQ | sed -e &#39;s/        /,/g&#39; | tee list.csv
select id, concat(&quot;\&quot;&quot;,name,&quot;\&quot;&quot;) as name
from students
EOQ
```

It gets messy when there are a lot of columns that need to be surrounded by quotes, or if there are quotes in the results that need to be escaped.

  [1]: http://en.wikipedia.org/wiki/Comma-separated_values




How can I output MySQL query results in CSV format?

I am trying to execute the following line in Command Prompt:

    curl -X POST -d &#39;{ &quot;method&quot; : &quot;account_info&quot;, &quot;params&quot; : [ { &quot;account&quot; : &quot;rHb9CJAWyB4rj91VRWn96DkukG4bwdtyTh&quot;} ] }&#39; http://s1.ripple.com:51234

However, I get the following:

    curl: (6) Could not resolve host: method
    curl: (7) Failed connect to :80; No error
    curl: (6) Could not resolve host: account_info,
    curl: (6) Could not resolve host: params
    curl: (7) Failed connect to :80; No error
    curl: (3) [globbing] illegal character in range specification at pos 2
    curl: (3) [globbing] unmatched brace at pos 2
    curl: (6) Could not resolve host: account
    curl: (7) Failed connect to :80; No error
    curl: (3) [globbing] unmatched close brace/bracket at pos 35
    curl: (3) [globbing] unmatched close brace/bracket at pos 1
    curl: (3) [globbing] unmatched close brace/bracket at pos 1
    unable to parse request

I am on Windows, and the error has to do with quotes, braces, and globbing. I tried escaping quotes by preceding them with a backslash, with no luck.

Having trouble escaping quotes and braces

    $string = &quot;my text has \&quot;double quotes\&quot; and &#39;single quotes&#39;&quot;;

How to remove all types of quotes (different languages) from `$string`?

How do I remove quotes from a string?

I know this (or similar) has been asked many times but having tried out numerous possibilities I&#39;ve not been able to find a a regex that works 100%.

I&#39;ve got a CSV file and I&#39;m trying to split it into an array, but encountering two problems: quoted commas and empty elements.

The CSV looks like:

    123,2.99,AMO024,Title,&quot;Description, more info&quot;,,123987564

The regex I&#39;ve tried to use is:

    thisLine.split(/,(?=(?:[^\&quot;]*\&quot;[^\&quot;]*\&quot;)*(?![^\&quot;]*\&quot;))/)

The only problem is that in my output array the 5th element comes out as 123987564 and not an empty string.

Regex to split a CSV

I&#39;m using Eclipse Juno on MacOSX Lion and have an issue with typing.

I often print one quote/apostrophe and move the caret. But in this Mac version of Eclipse the quote as I type is highlighted by orange marker (it seems like Mac smart quotes feature) and when I move caret - quote disappears. (in Xcode and Appcode everything works ok).

I tried 

    defaults write NSGlobalDomain AutomaticQuoteSubstitutionEnabled -bool false

to disable smart qotes globally, restarted the computer, but this doesn&#39;t help. 

Also I tried to find in Eclipse preferences something related to &quot;quote&quot;, &quot;smart&quot;, &quot;correction&quot; but had no luck. 

Tried to disable &#39;Smart insert mode&#39; - useless.

Tried to set `Java -&gt; Typing -&gt; Automatically close -&gt; Strings` to `on` - but now, when I move caret after printing a quote, Eclipse doubles it instead of removing like before. Also annoying. Why on earth in other programs quotes handling works as expected but I can&#39;t get it work the same way in Eclipse?

By the way, when I recently pressed quote and then a I got &#39;&#228;&#39; symbol. So I assume this is something related to autocorrection.  
But even if I disable `Language &amp; Text -&gt; Automatic replacement`, Eclipse replaces &lt;kbd&gt;&quot;&lt;/kbd&gt; + &lt;kbd&gt;a&lt;/kbd&gt; to &lt;kbd&gt;&#228;&lt;/kbd&gt;.

How to disable this behavior?

MacOSX: how to disable accented characters input

How can I explode the following string:

    Lorem ipsum &quot;dolor sit amet&quot; consectetur &quot;adipiscing elit&quot; dolor

into

    array(&quot;Lorem&quot;, &quot;ipsum&quot;, &quot;dolor sit amet&quot;, &quot;consectetur&quot;, &quot;adipiscing elit&quot;, &quot;dolor&quot;)

So that the text in quotation is treated as a single word.

Here&#39;s what I have for now:

    $mytext = &quot;Lorem ipsum %22dolor sit amet%22 consectetur %22adipiscing elit%22 dolor&quot;
    $noquotes = str_replace(&quot;%22&quot;, &quot;&quot;, $mytext&quot;);
    $newarray = explode(&quot; &quot;, $noquotes);

but my code divides each word into an array. How do I make words inside quotation marks treated as one word?

PHP explode the string, but treat words in quotes as a single word

Can there be quotes around JSON numbers? In most of the search links, it seems that numbers do not &quot;require&quot; quotes. But, should the parsers accept both `&quot;attr&quot; : 6` and `&quot;attr&quot; : &quot;6&quot;`?

If `MyParser` has a method `getInt` to get a number given the key, should `MyParser.getInt(&quot;attr&quot;)` return `6` in both cases, or throw an exception in the latter case? 

Can JSON numbers be quoted?

I know there are a few questions about this on SO, but I couldn&#39;t find what I was looking for.

I&#39;m using [pyyaml][1] to read (`.load()`) a `.yml` file, modify or add a key, and then write it (`.dump()`) again. The problem is that I want to keep the file format post-dump, but it changes.

For example, I edit the key `en.test.index.few` to say `&quot;Bye&quot;` instead of `&quot;Hello&quot;`

**Python:** 

&lt;!-- language: lang-python --&gt;

    with open(path, &#39;r&#39;, encoding = &quot;utf-8&quot;) as yaml_file:
        self.dict = pyyaml.load(yaml_file)

Then, afther changing the key:

&lt;!-- language: lang-python --&gt;

    with open(path, &#39;w&#39;, encoding = &quot;utf-8&quot;) as yaml_file:
        dump = pyyaml.dump(self.dict, default_flow_style = False, allow_unicode = True, encoding = None)
        yaml_file.write( dump )

**Yaml:**

*Before:*

&lt;!-- language: lang-yaml --&gt;

    en:
      test:
        new: &quot;Bye&quot;
        index:
          few: &quot;Hello&quot;
      anothertest: &quot;Something&quot;



*After:*

&lt;!-- language: lang-yaml --&gt;

    en:
      anothertest: Something
      test:
        index:
          few: Hello
        new: Bye



Is there a way to keep the same format?, for example the qoutes and order. Am I using the wrong tool for this?

I know maybe the original file it&#39;s not entirely correct, but I have no control over it (it&#39;s a Ruby on Rails i18n file). 

Thank you very much.

  [1]: http://pyyaml.org/

PyYAML dump format

What is the difference between single quotes and double quotes in SQL?

What is the difference between single and double quotes in SQL?

I&#39;m curious about this code:

    cout &lt;&lt; &#39;test&#39;; // Note the single quotes.

gives me an output of `1952805748`. 

My question: Is the output an address in memory or something?

What do single quotes do in C++ when used on multiple characters?

Should or should I not wrap quotes around variables in a shell script?

For example, is the following correct:

    xdg-open $URL
    [ $? -eq 2 ]

or

    xdg-open &quot;$URL&quot;
    [ &quot;$?&quot; -eq &quot;2&quot; ]

And if so, why?




When should I wrap quotes around a shell variable?

I&#39;m sure there used to be a plugin for this kinda stuff, but now that I need it, I can&#39;t seem to find it (naturally), so I&#39;ll just ask nice and simple.

What is the easiest way to select between brackets, or quotes, or generally a list of matching characters?

       write ( *, &#39;(a)&#39; ) &#39;Computed solution coefficients:&#39;

For example, here I&#39;d like to select `(a)`, or `Computed solution coefficients:`.

I&#39;m not interested in multiline, just cases which occur on one line.

How to select between brackets (or quotes or ...) in Vim?

Here is how I&#39;m currently converting **XMLDocument** to **String**

    StringWriter stringWriter = new StringWriter();
    XmlTextWriter xmlTextWriter = new XmlTextWriter(stringWriter);
    
    xmlDoc.WriteTo(xmlTextWriter);
    
    return stringWriter.ToString();

The problem with this method is that if I have **&quot;** ((quotes) which I have in attributes) it escapes them.

For Instance:

    &lt;Campaign name=&quot;ABC&quot;&gt;
    &lt;/Campaign&gt;
Above is the expected XML. But it returns

    &lt;Campaign name=\&quot;ABC\&quot;&gt;
    &lt;/Campaign&gt;

I can do **String.Replace &quot;\&quot;** but is that method okay? Are there any side-effects? Will it work fine if the XML itself contains a **&quot;\&quot;**

Convert XmlDocument to String

I&#39;m outputting values from a database (it isn&#39;t really open to public entry, but it is open to entry by a user at the company -- meaning, I&#39;m not worried about [XSS][1]).

I&#39;m trying to output a tag like this:

    &lt;a href=&quot;&quot; onclick=&quot;DoEdit(&#39;DESCRIPTION&#39;);&quot;&gt;Click Me&lt;/a&gt;

DESCRIPTION is actually a value from the database that is something like this:

    Prelim Assess &quot;Mini&quot; Report

I&#39;ve tried replacing &quot; with \&quot;, but no matter what I try, Firefox keeps chopping off my JavaScript call  after the space after the word *Assess*, and it is causing all sorts of issues.

I must bemissing the obvious answer, but for the life of me I can&#39;t figure it out.

Anyone care to point out my idiocy?

Here is the entire HTML page (it will be an [ASP.NET][2] page eventually, but in order to solve this I took out everything else but the problem code)

    &lt;html&gt;
        &lt;body&gt;
            &lt;a href=&quot;#&quot; onclick=&quot;DoEdit(&#39;Preliminary Assessment \&quot;Mini\&quot;&#39;); return false;&quot;&gt;edit&lt;/a&gt;
        &lt;/body&gt;
    &lt;/html&gt;

  [1]: http://en.wikipedia.org/wiki/Cross-site_scripting
  [2]: http://en.wikipedia.org/wiki/.NET_Framework





Escape quotes in JavaScript

I am trying to use a string that contains double quotes in the title attribute of an anchor. So far I tried these:

    &lt;a href=&quot;..&quot; title=&quot;Some \&quot;text\&quot;&quot;&gt;Some text&lt;/a&gt;
    &lt;!-- The title looks like `Some \` --!&gt;

and

    &lt;a href=&quot;..&quot; title=&quot;Some &amp;quot;text&amp;quot;&quot;&gt;Some text&lt;/a&gt;
    &lt;!-- The title looks like `Some ` --!&gt;

Please note that using single quotes is _not_ an option.



How to escape double quotes in a title attribute

Is there a specific time when I should use `&quot;&quot;` vs `&#39;&#39;`?

I&#39;ve been using single quotes most of the time because it&#39;s easier to type but I&#39;m not sure if I should.


e.g. `get &#39;user/new&#39;` vs. `get &quot;user/new&quot;`

Double vs single quotes

As stated in, [When did single quotes in HTML become so popular?][1] and [Jquery embedded quote in attribute][2], the Wikipedia entry on [HTML][3] says the following:

&gt; The single-quote character (&#39;), when used to quote an attribute value, must also be escaped as `&amp;#x27;` or `&amp;#39;` (should NOT be escaped as `&amp;apos;` except in XHTML documents) when it appears within the attribute value itself.

Why shouldn&#39;t `&amp;apos;` be used?  Also, is `&amp;quot;` safe to be used instead of `&amp;#34;`?


  [1]: https://stackoverflow.com/questions/242766/when-did-single-quotes-in-html-become-so-popular
  [2]: https://stackoverflow.com/questions/1263141/jquery-embedded-quote-in-attribute
  [3]: https://en.wikipedia.org/wiki/HTML#Character_and_entity_references

Why shouldn&#39;t `&amp;apos;` be used to escape single quotes?

In Bash, what are the differences between single quotes (`&#39;&#39;`) and double quotes (`&quot;&quot;`)?

Difference between single and double quotes in Bash

&gt; Always code as if the guy who ends up
&gt; maintaining your code will be a
&gt; violent psychopath who knows where you
&gt; live.

I found this at somebody&#39;s blog, and it introduces as Rick Osborne&#39;s.  But I google this, and other people says: Martin Golding&#39;s, John Woods&#39; and Damian Conway&#39;s...  Yes, Damian Conway used this quote in &quot;[Perl Best Practices][1]&quot; (2005) but Damian doesn&#39;t mention who wrote it.

Does anybody know who the real author of this aphorism is?


  [1]: https://books.google.co.id/books?id=gJf9tI2mytIC&amp;pg=PT27#v=snippet&amp;q=%22Always%20code%20as%20if%20the%20guy%20who%20ends%20up%20maintaining%20your%20code%20will%20be%20a%20violent%20psychopath%20who%20knows%20where%20you%20live%22&amp;f=false

Who wrote this programing saying? &quot;Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.&quot;

I am trying to learn the best way to write queries. I also understand the importance of being consistent. Until now, I have randomly used single quotes, double quotes, and backticks without any real thought.

Example:

    $query = &#39;INSERT INTO table (id, col1, col2) VALUES (NULL, val1, val2)&#39;;

Also, in the above example, consider that `table`, `col1`, `val1`, etc. may be variables.

What is the standard for this? What do you do?

&lt;sub&gt;I&#39;ve been reading answers to similar questions on here for about 20 minutes, but it seems like there is no definitive answer to this question.&lt;/sub&gt;

When to use single quotes, double quotes, and backticks in MySQL

How do I get the substring `&quot; It&#39;s big \&quot;problem  &quot;` using a regular expression?

    s = &#39; function(){  return &quot; It\&#39;s big \&quot;problem  &quot;;  }&#39;;     

Regex for quoted string with escaping quotes

I know that in PHP, the only difference between double quotes and single quotes is the interpretation of variable inside a string and the treatment of escape characters.

In JavaScript, I often see double quotes used in strings. Is there a particular reason for that, or are single quotes exactly the same as double quotes?

Difference between single quotes and double quotes in Javascript

Can anybody help with effective and safe way of removing quotes from batch variables?

I have written a batch file which successfully imports a list of parameters %1, %2, %3 etc. and places them into named variables.  Some of these parameters contain multiple words, and therefor are enclosed in double quotes.

    &gt; &quot;Susie Jo&quot; (%1)  
    &gt; &quot;Smith Barnes&quot; (%2)  
    &gt; &quot;123 E. Main St.&quot; (%3)  

These %variables are next placed in named variables:

    &gt; set FirstName=%1  
    &gt; set LastName=%2  
    &gt; set ShipAddr=%3  

verification of variables is done by echo.
    &gt; echo.%FirstName%  
    &gt; echo.%LastName%  
    &gt; echo.%ShipAddr%  

results display as

    &quot;Susie Jo&quot;  
    &quot;Smith Barnes&quot;  
    &quot;123 E. Main St.&quot;  

I need to eliminate the included quotes on selected variables.  For instance, FirstName and LastName are used elsewhere and must not include quotes.

In a test batch file I was successful at eliminating quotes using the ~tilde character in variables.

    &gt; set FirstName=%~1
    &gt; set LastName=%~2 

I thought I had the solution, but I soon experienced unusual behavior with execution of batch files.  Suddenly CMD is no recognizing long path statments.  Normal execution of batch file from full path 

    &gt; C:\Documents and Settings\Administrator\My Documents\Txt\batchtest\dataout.bat
returns

    &gt; &#39;C:\Documents&#39; is not recognized as an internal or external command....
So it would appear that the addition of the ~tilde character to the in-coming %1 %2...%n variables has caused some change.  Possibly some environment variables have been altered?

I also tried clearing quotes from within variable with various attempts using the FOR command.  That seems awkward and I have been unable to learn how to accomplish this by creating a list of variable to perform the task:

something like this:

    for %%g in (%FirstName% %LastName%) do (
    set %%g=%%~g
    set %%h=%%~h
    set FirstName=%%~g
    set LastName=%%h
    echo.%FirstName% %LastName%
    )
I think I have two issues. 

1)  My &#39;short and sweet&#39; idea of inserting ~tilde in the incoming %1 %2 variables (%~1, etc) seems to have affected some settings and altered how CMD navigates long pathnames.

2)  I&#39;m still in search of a clean and easy way to eliminate quotes from selected named variables.  

Any help for those more experienced would be most appreciated.  I&#39;m at the end of my skills here... need some guidance please!

edit 12/26/2009 13:36 PST
entire batch file:

    
```
:: dataout.bat  
:: revision 12/25/2009 add ~tilde to incoming %variables to eliminate embedded &quot;quotation marks.  
:: writes address list using command line parameters  
:: writes data output list for QBooks IIF import  
:: writes Merchant Order data for RUI  
:: sample command line string for testing  
:: listmail[firstname][lastname][&quot;address string&quot;][&quot;city string&quot;][state][zip][Order#][PurchDate][Regname][&quot;FirstName LastName&quot;][TransactionID][PaymentMethod][Total][ProductID][Qty][Price_Each][PackPrep] [Shipping] [CommissionPmt] [Invoice#]  
:: example: dataout Bellewinkle Moose &quot;123 Green Forest Way&quot; &quot;Vancouver&quot; WA 98664 1004968 05/25/2009 &quot;Bellewinkle Moose&quot; &quot;Olive Oyl&quot; 101738 &quot;On Account&quot; 20.67 FK-1P 1 8.95 3.00 1.39 239  
@echo off  
cls  
c:  
cd\  
cd documents and settings\administrator\my documents\txt\batchtest  
echo processing %1 %2  
:VARISET  
:: Convert %n command line parameters to string variables  
set ($FirstName)=%~1  
set ($LastName)=%~2  
set ($BillingAddress1)=%~3  
set ($BillingCity)=%~4  
set ($BillingState)=%~5  
set ($BillingPostal)=%~6  
set ($OrderNumber)=%~7  
set ($Purch_Date)=%~8  
set ($RegistrationName)=%~9  
shift  
set ($TransactionID)=%~9  
shift  
set ($PaymentMethod)=%~9  
shift  
set ($Total)=%~9  
shift
set ($ProductIdentifier)=%~9  
shift  
set ($Quantity)=%~9  
shift  
set ($Price_Each)=%~9  
shift  
set ($Pack_Prep)=%~9  
shift  
set ($Shipping)=%~9  
shift  
set ($ServiceFee)=%~9  
shift  
set ($Discount)=%~9  
shift  
set ($Invoice)=%~9  
shift  
set ($UnitPrice)=%~9  
set _ShipCombName=%($FirstName)% %($LastName)%  
echo ship combo name is %_ShipCombName%  
pause  
:: write string varibables to logfile  
echo FN %($FirstName)% LN %($LastName)% BA %($BillingAddress1)% %($BillingCity)% %($BillingState)% %($BillingPostal)% %($OrderNumber)% %($Purch_Date)% %($RegistrationName)% %($TransactionID)% %($PaymentMethod)% %($Total)% %($ProductIdentifier)% %($Quantity)% %($Price_Each)% %($Pack_Prep)% %($Shipping)% %($ServiceFee)% %($Discount)% %($Invoice)% %($UnitPrice)% %_ShipCombName% &gt;&gt; d_out_log.txt  
:: Assign Account by Service Provider  
IF /i %($PaymentMethod)%==Amazon Receivables SET _QBAcct=Amazon.com  
:: 12-25-2009 added second Amazon pm&#39;t method for versatility  
IF /i %($PaymentMethod)%==Amazon SET _QBAcct=Amazon.com  
IF /i %($PaymentMethod)%==MAST SET _QBAcct=Auth/Net  
IF /i %($PaymentMethod)%==MasterCard SET _QBAcct=Auth/Net  
IF /i %($PaymentMethod)%==Visa SET _QBAcct=Auth/Net  
IF /i %($PaymentMethod)%==PayPal SET _QBAcct=PayPalPmts  
IF /i %($PaymentMethod)%==On Account SET _QBAcct=%($RegistrationName)%  
IF /i %($PaymentMethod)%==Mail SET _QBAcct=%($RegistrationName)%  
IF /i %($PaymentMethod)%==AMER SET _QBAcct=Auth/Net  
IF /i %($PaymentMethod)%==DISC SET _QBAcct=Auth/Net  
:: Assign Rep designator based on QBAccount  
IF /i %($PaymentMethod)%==Amazon Receivables SET _Rep=Amazon  
:: 12-25-2009 added second Amazon pm&#39;t method for versatility  
IF /i %($PaymentMethod)%==Amazon SET _Rep=Amazon  
IF /i %($PaymentMethod)%==MAST SET _Rep=BlueZap  
IF /i %($PaymentMethod)%==MasterCard SET _Rep=BlueZap  
IF /i %($PaymentMethod)%==Visa SET _Rep=BlueZap  
IF /i %($PaymentMethod)%==PayPal SET _Rep=BlueZap  
IF /i %($PaymentMethod)%==On Account SET _Rep=R B  
IF /i %($PaymentMethod)%==Mail SET _Rep=R B  
IF /i %($PaymentMethod)%==AMER SET _Rep=BlueZap  
IF /i %($PaymentMethod)%==DISC SET _Rep=BlueZap  
:: check for duplicate address data  
findstr /i /s &quot;%_ShipCombName%&quot; addrlist.txt  
echo errorlevel: %errorlevel%  
if errorlevel 1 goto :ADDRWRITE  
if errorlevel 0 goto :ADDRFOUND  
:ADDRWRITE  
echo %_ShipCombName% &gt;&gt; addrlist.txt  
echo %($BillingAddress1)% &gt;&gt; addrlist.txt  
echo %($BillingCity)% %($BillingState)% %($BillingPostal)% &gt;&gt; addrlist.txt  
echo. &gt;&gt; addrlist.txt  
echo Address File Written  
:ADDRFOUND  
echo selected rep is %_Rep%  
echo selected account is: %_QBAcct%  
pause  
:: RUI OUT  
:: write Merchant Order ID &amp; RUI Order ID to RUI  
:: check for duplicate RUI data in writeRUI.txt  
cd..  
cd RegKOut  
find /i &quot;%($OrderNumber)%&quot; writeRUI.txt  
echo errorlevel: %errorlevel%  
if errorlevel 1 goto :RUIWRITE  
if errorlevel 0 goto :IIFWRITE  
:RUIWRITE  
echo %($Invoice)%	%($OrderNumber)% &gt;&gt; writeRUI.txt  
:: end write RUI  
:: IIF OUT  
:IIFWRITE  
:: Check for duplicate invoice data in writeIIF.txt  
find /i &quot;%($OrderNumber)%&quot; writeIIF.txt  
echo errorlevel: %errorlevel%  
if errorlevel 1 goto :HEADWRITE  
if errorlevel 0 goto :LINEWRITE  
:HEADWRITE  
:: write Header, Ship/Handling, discount, Rep &amp; commission data to QB IIF import file  
echo %($OrderNumber)%	%($Purch_Date)%	Invoice	%($TransactionID)%	%_QBAcct%	Accounts Receivable				%($Total)%	%_Rep% &gt;&gt; writeIIF.txt    
echo 						H/P	%($Pack_Prep)%	1	? &gt;&gt; writeIIF.txt  
echo 						SHP	%($Shipping)%	1	? &gt;&gt; writeIIF.txt  
echo 						DISC	%($Discount)%	1	? &gt;&gt; writeIIF.txt  
echo 						Comm	%($ServiceFee)%	1	? &gt;&gt; writeIIF.txt  
:LINEWRITE  
IF /i %($ProductIdentifier)% equ PH-1 goto WRITE_DEFA ELSE goto WRITE_DISC  
echo %($ProductIdentifier)%  
:WRITE_DISC  
::writes discounted prices parsed from custom variable:  
echo 						%($ProductIdentifier)%	%($Price_Each)%	%($Quantity)%	? &gt;&gt; writeIIF.txt  
goto :EOF  
:WRITE_DEFA  
:writes default prices parsed from Product data  
echo 						%($ProductIdentifier)%	%($UnitPrice)%	%($Quantity)%	? &gt;&gt; writeIIF.txt  
goto :EOF  
:: 3-second delay  
:: TYPE NUL | CHOICE.COM /N /CY /TY,3 &gt;NUL  
:EOF  

```

Removing double quotes from variables in batch file creates problems with CMD environment

I want to initialize a String in Java, but that string needs to include quotes; for example: `&quot;ROM&quot;`. I tried doing:

    String value = &quot; &quot;ROM&quot; &quot;;

but that doesn&#39;t work. How can I include `&quot;`s within a string?

How to enter quotes in a Java string?

I&#39;ve tried various forms of the following in a bash script:

    #!/bin/bash
    svn diff $@ --diff-cmd /usr/bin/diff -x &quot;-y -w -p -W $COLUMNS&quot;
But I can&#39;t get the syntax to correctly expand the `COLUMNS` environment variable.

I&#39;ve tried various forms of the following:

    svn diff $@ --diff-cmd /usr/bin/diff -x &#39;-y -w -p -W $COLUMNS&#39;
and

    svn diff $@ --diff-cmd /usr/bin/diff -x &#39;-y -w -p -W ${COLUMNS}&#39;
and

    eval svn diff $@ --diff-cmd /usr/bin/diff -x &quot;-y -w -p -W $COLUMNS&quot;

Suggestions?

How to use an environment variable inside a quoted string in Bash

I have a table `test(id,name)`.

I need to insert values like:  `user&#39;s log`, `&#39;my user&#39;`, `customer&#39;s`.

     insert into test values (1,&#39;user&#39;s log&#39;);
     insert into test values (2,&#39;&#39;my users&#39;&#39;);
     insert into test values (3,&#39;customer&#39;s&#39;);

I am getting an error if I run any of the above statements.

If there is any method to do this correctly please share. I don&#39;t want any prepared statements.

Is it possible using sql escaping mechanism?



Insert text with single quotes in PostgreSQL

I am trying to write a YAML dictionary for internationalisation of a Rails project. I am a little confused though, as in some files I see strings in double-quotes and in some without. A few points to consider:

 - [example 1][1] - all strings use double quotes;
 - [example 2][2] - no strings (except the last two) use quotes;
 - the [YAML cookbook][3] says: *Enclosing strings in double quotes allows you to use escaping to represent ASCII and Unicode characters.* Does this mean I need to use double quotes only when I want to escape some characters? If yes - why do they use double quotes everywhere in the first example - only for the sake of unity / stylistic reasons?
 - the last two lines of example 2 use `!` - the non-specific tag, while the last two lines of the first example don&#39;t - and they both work. 

My question is: what are the rules for using the different types of quotes in YAML?

Could it be said that:

 - in general, you don&#39;t need quotes;
 - if you want to escape characters use double quotes;
 - use `!` with single quotes, when... ?!?

  [1]: https://github.com/plataformatec/devise/blob/master/config/locales/en.yml
  [2]: https://github.com/tigrish/devise-i18n/blob/v0.9.0/locales/en.yml
  [3]: http://www.yaml.org/YAML_for_ruby.html#double-quoted_strings

YAML: Do I need quotes for strings in YAML?

Being completely new to PL/pgSQL , what is the meaning of double dollar signs in [this function][1]:

    CREATE OR REPLACE FUNCTION check_phone_number(text)
    RETURNS boolean AS $$
    BEGIN
      IF NOT $1 ~  e&#39;^\\+\\d{3}\\ \\d{3} \\d{3} \\d{3}$&#39; THEN
        RAISE EXCEPTION &#39;Wrong formated string &quot;%&quot;. Expected format is +999 999&#39;;
      END IF;
      RETURN true; 
    END;
    $$ LANGUAGE plpgsql STRICT IMMUTABLE;


  [1]: http://postgres.cz/wiki/PL/pgSQL_%28en%29

I&#39;m guessing that, in `RETURNS boolean AS $$`, `$$` is a placeholder.

The last line is a bit of a mystery: `$$ LANGUAGE plpgsql STRICT IMMUTABLE;`

By the way, what does the last line mean?

What are &#39;$$&#39; used for in PL/pgSQL

I want to run a command from a *bash script* which has single quotes and some other commands inside the single quotes and a variable.

e.g. `repo forall -c &#39;....$variable&#39;`


In this format, `$` is escaped and the variable is not expanded.

I tried the following variations but they were rejected:

    repo forall -c &#39;....&quot;$variable&quot; &#39;

    repo forall -c &quot; &#39;....$variable&#39; &quot;

    &quot; repo forall -c &#39;....$variable&#39; &quot;

    repo forall -c &quot;&#39;&quot; ....$variable &quot;&#39;&quot;

If I substitute the value in place of the variable the command is executed just fine.

Please tell me where am I going wrong.

Expansion of variables inside single quotes in a command in Bash

How do I insert a value in MySQL that consist of single or double quotes. i.e

    This is Ashok&#39;s Pen.

The single quote will create problems. There might be other escape characters. 

How do you insert the data properly?




How to escape single quotes in MySQL

I have a Bash script where I want to keep quotes in the arguments passed. 

Example:

    ./test.sh this is &quot;some test&quot;

then I want to use those arguments, and re-use them, including quotes and quotes around the whole argument list.

I tried using `\&quot;$@\&quot;`, but that removes the quotes inside the list.

How do I accomplish this?

How to keep quotes in Bash arguments?

How would I go about replacing all of the double quotes in my batch file&#39;s parameters with escaped double quotes? This is my current batch file, which expands all of its command line parameters inside the string:

    @echo off
    call bash --verbose -c &quot;g++-linux-4.1 %*&quot;

It then uses that string to make a call to Cygwin&#39;s bash, executing a Linux cross-compiler. Unfortunately, I&#39;m getting parameters like these passed in to my batch file:

    &quot;launch-linux-g++.bat&quot; -ftemplate-depth-128 -O3 -finline-functions 
    -Wno-inline -Wall  -DNDEBUG   -c 
    -o &quot;C:\Users\Me\Documents\Testing\SparseLib\bin\Win32\LinuxRelease\hello.o&quot; 
    &quot;c:\Users\Me\Documents\Testing\SparseLib\SparseLib\hello.cpp&quot;

Where the first quote around the first path passed in is prematurely ending the string being passed to GCC, and passing the rest of the parameters directly to bash (which fails spectacularly.)

I imagine if I can concatenate the parameters into a single string then escape the quotes it should work fine, but I&#39;m having difficulty determining how to do this. Does anyone know?

Escaping Double Quotes in Batch Script

I have this command that does what I want but I can&#39;t get to alias it in my .bashrc (note that it uses both single and double quotes):

    svn status | awk &#39;$1 ==&quot;M&quot;{print $2;}&#39;

I&#39;ve tried:
  
    alias xx=&quot;svn status | awk &#39;$1 ==\&quot;M\&quot;{print $2;}&#39;&quot;

And some other common sense combinations with no luck.. I know that bash is very picky with quotes.. So what&#39;s the correct way to alias it and why ? Thanks

bash alias command with both single and double quotes

When I execute a script in a Linux shell, I get this output:

    dquote&gt;

What does this mean?

I get &quot;dquote&gt;&quot; as a result of executing a program in linux shell

I have a python editor where the user is entering a script or code, which is then put into a main method behind the scenes, while also having every line indented. The problem is that if a user has a multi line string, the indentation made to the whole script affects the string, by inserting a tab in every space. A problem script would be something so simple as:

    &quot;&quot;&quot;foo
    bar
    foo2&quot;&quot;&quot;

So when in the main method it would look like:

    def main():
        &quot;&quot;&quot;foo
        bar
        foo2&quot;&quot;&quot;

and the string would now have an extra tab at the beginning of every line. 


How to remove extra indentation of Python triple quoted multi-line strings?

How do you run the following command in PowerShell?

&gt; C:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe -verb:sync -source:dbfullsql=&quot;Data Source=mysource;Integrated Security=false;User ID=sa;Pwd=sapass!;Database=mydb;&quot; -dest:dbfullsql=&quot;Data Source=.\mydestsource;Integrated Security=false;User ID=sa;Pwd=sapass!;Database=mydb;&quot;,computername=10.10.10.10,username=administrator,password=adminpass&quot;


How to run an EXE file in PowerShell with parameters with spaces and quotes

The following code

    number=1
    if [[ $number =~ [0-9] ]]
    then
      echo matched
    fi

works. If I try to use quotes in the regex, however, it stops:

    number=1
    if [[ $number =~ &quot;[0-9]&quot; ]]
    then
      echo matched
    fi

I tried `&quot;\[0-9\]&quot;`, too. What am I missing?

Funnily enough, [bash advanced scripting guide][1] suggests this should work.

Bash version 3.2.39.


  [1]: http://www.tldp.org/LDP/abs/html/abs-guide.html#REGEXMATCHREF

bash regex with quotes?

I need to pass a string to a program as its argument from the Bash CLI, e.g

    program &quot;don&#39;t do this&quot;

The string may include any character like `&#39;$&#39;`, `&#39;\&#39;`, etc. and I don&#39;t want Bash to do any modification. So I think about using single quotes.

However the following does not work:

     program &#39;don\&#39;t do this&#39;            //escape doesn&#39;t work in single quote

While the following two works:

     program $&#39;dont\&#39;t do this&#39;          //seems fine, but any other side effects?
     program &#39;dont&#39;\&#39;&#39;do this&#39;           //breaking into 3 parts

The first approach seems better in that it acquires less pre modification (put the dollar symbol in front and substitute every `\` to `\\`), but I don&#39;t know what else the DOLLAR SIGN might do.

I&#39;ve really googled this but I can&#39;t find what I need...



How does the leading dollar sign affect single quotes in Bash?

From [this q/a][1], I deduced that matching all instances of a given regex *not* inside quotes, is impossible. That is, it can&#39;t match escaped quotes (ex: `&quot;this whole \&quot;match\&quot; should be taken&quot;`). If there is a way to do it that I don&#39;t know about, that would solve my problem.

If not, however, I&#39;d like to know if there is any efficient alternative that could be used in JavaScript. I&#39;ve thought about it a bit, but can&#39;t come with any elegant solutions that would work in most, if not all, cases.

Specifically, I just need the alternative to work with .split() and .replace() methods, but if it could be more generalized, that would be the best.

*For Example:*&lt;br/&gt;
An input string of:&lt;br/&gt; `+bar+baz&quot;not+or\&quot;+or+\&quot;this+&quot;foo+bar+`&lt;br/&gt;
replacing + with #, not inside quotes, would return:&lt;br/&gt; `#bar#baz&quot;not+or\&quot;+or+\&quot;this+&quot;foo#bar#`

  [1]: https://stackoverflow.com/questions/2700953/a-regex-to-match-a-comma-that-isnt-surrounded-by-quotes

Regex to match all instances not inside quotes

I&#39;ve been reading through Thomas&#39; Programming Ruby 1.9 and came upon the alternative delimited single and double-quoting methods (`%q / %Q`). I&#39;ve known of them from other Ruby language references as well.

    %q/I&#39;m acting like a single-quoted string/

    %Q|&quot;I&#39;m acting like a double-quoted string&quot; --Anonymous|

I have not been working with Ruby for long, but I have _never_ encountered this quoting method in production code.

Other than the obvious ability to **avoid internally escaping quotes** with backslashes, what are the common use cases for this method of quoting over regular single or double quotes? Are they typically used in single or multiline strings? If used in multiline strings, are they ever favored over HEREDOC strings? Is there a particular Ruby idiom where they&#39;re commonly found?

What is the use case for Ruby&#39;s %q / %Q quoting methods?

In a Windows batch file, when you do the following:  
&gt;`set myvar=&quot;c:\my music &amp; videos&quot;`

the variable `myvar` is stored with the quotes included. Honestly I find that very stupid. The quotes are just to tell where the string begins and ends, not to be stored as part of the value itself.  
How can I prevent this from happening?

Thanks.


Dealing with quotes in Windows batch scripts

In PHP, a string enclosed in &quot;double quotes&quot; will be parsed for variables to replace whereas a string enclosed in &#39;single quotes&#39; will not. In Python, does this also apply?

Is there any difference between &quot;string&quot; and &#39;string&#39; in Python?

Does JavaScript have a built-in function like PHP&#39;s `addslashes` (or `addcslashes`) function to add backslashes to characters that need escaping in a string?

For example, this:

&gt; This is a demo string with
&gt; &#39;single-quotes&#39; and &quot;double-quotes&quot;.

...would become:

&gt; This is a demo string with
&gt; \&#39;single-quotes\&#39; and
&gt; \&quot;double-quotes\&quot;.


Escaping Strings in JavaScript

I&#39;ve started learning Python recently and I don&#39;t understand why Python behaves like this:

&lt;pre&gt;
&gt;&gt;&gt; &quot;OK&quot;
&#39;OK&#39;
&gt;&gt;&gt; &quot;&quot;&quot;OK&quot;&quot;&quot;
&#39;OK&#39;
&gt;&gt;&gt; &quot;not Ok&#39;
  File &quot;&amp;lt;stdin&amp;gt;&quot;, line 1
    &quot;not Ok&#39;
           ^
SyntaxError: EOL while scanning string literal
&gt;&gt;&gt; &quot;not OK&quot;&quot;&quot;
&#39;not OK&#39;
&lt;/pre&gt;

Why doesn&#39;t it give an error for the last statement as the number of quotes does not match?

Why doesn&#39;t Python give any error when quotes around a string do not match?

How can I escape double quotes inside a double string in Bash?

For example, in my shell script

    #!/bin/bash

    dbload=&quot;load data local infile \&quot;&#39;gfpoint.csv&#39;\&quot; into table $dbtable FIELDS TERMINATED BY &#39;,&#39; ENCLOSED BY &#39;\&quot;&#39; LINES TERMINATED BY \&quot;&#39;\n&#39;\&quot; IGNORE 1 LINES&quot;

I can&#39;t get the `ENCLOSED BY &#39;\&quot;&#39;` with double quote to escape correctly. I can&#39;t use single quotes for my variable, because I want to use variable `$dbtable`.






How can I escape a double quote inside double quotes?

Suppose you have a character vector:

    char &lt;- c(&quot;one&quot;, &quot;two&quot;, &quot;three&quot;)

When you make reference to an index value, you get the following:

    &gt; char[1]
    [1] &quot;one&quot;

How can you strip off the quote marks from the return value to get the following?

    [1] one



Remove quotes from a character vector in R

I try to execute the following command :

    mysql AMORE -u username -ppassword -h localhost -e &quot;SELECT  host  FROM amoreconfig&quot;

I store it in a string :

    cmd=&quot;mysql AMORE -u username -ppassword -h localhost -e\&quot;SELECT  host  FROM amoreconfig\&quot;&quot;

Test it : 

    echo $cmd
    mysql AMORE -u username -ppassword -h localhost -e&quot;SELECT host FROM amoreconfig&quot;

Try to execute by doing : 

    $cmd

And I get the help page of mysql :

    mysql  Ver 14.14 Distrib 5.1.31, for pc-linux-gnu (i686) using readline 5.1
    Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
    This software comes with ABSOLUTELY NO WARRANTY. This is free software,
    and you are welcome to modify and redistribute it under the GPL license
    Usage: mysql [OPTIONS] [database]
    (...)

I guess I am doing something plain wrong with the quotes but can&#39;t find out what is the problem. 


How to execute a bash command stored as a string with quotes and asterisk

I want to store a URL prefix in an Windows environment variable. The ampersands in the query string makes this troublesome though.

For example: I have a URL prefix of `http://example.com?foo=1&amp;bar=` and want to create a full URL by providing a value for the `bar` parameter. I then want to launch that URL using the &quot;start&quot; command.

Adding quotes around the value for the SET operation is easy enough:

    set myvar=&quot;http://example.com?foo=1&amp;bar=&quot;

Windows includes the quotes in the actual value though (thanks Windows!):

    echo %myvar%
    &quot;http://example.com?foo=1&amp;bar=true&quot;

I know that I can strip quotes away from batch file arguments by using tilde:

    echo %~1

However, I can&#39;t seem to do it to named variables:

    echo %~myvar%
    %~myvar%

What&#39;s the syntax for accomplishing this?

Remove quotes from named environment variables in Windows scripts

Is there a native function or solid class/library for writing an array as a line in a CSV file without enclosures? `fputcsv` will default to `&quot;` if nothing is passed in for the enclosure param. Google is failing me (returning results for a whole bunch of pages about `fputcsv`), and PEAR&#39;s libraries do more or less the same things as `fputcsv`.

Something that works exactly like `fputcsv`, but will allow the fields to remain unquoted.

currently: `&quot;field 1&quot;,&quot;field 2&quot;,field3hasNoSpaces`

desired: `field 1,field 2,field3hasNoSpaces`

All Quotes Solutions on Gang of Coders

Total of 49 Quotes Solutions