Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>One way is to work with delayed expansion inside of the batch, because then the special characters lose there "special" meanings.</p> <p>The only problem is to get the parameters into a variable.</p> <p>Something like this could help</p> <pre><code>@echo off setlocal DisableDelayedExpansion rem ** At this point the delayedExpansion should be disabled rem ** otherwise an exclamation mark in %1 can remove carets set "param1=%~1" setlocal EnableDelayedExpansion rem ** Now you can use the param1, independent of the content, even with carets or quotes rem ** but be careful with call's, because they start a second round of expansion echo !param1! set "tmp=!param1:~1,4!" </code></pre> <p>Now the parameters can be surround by quotation marks, so there the carets aren't neccessary anymore. Example launcher.bat "abc>def&amp;geh%ijk|lmn^opq!"</p> <p>The only remaining problematic special character seems to be the quotation mark.</p> <p><strong>[Edit/Improve] I create another way to retrieve a parameter, I assume it can accept any string also your second example.</strong><br> Even really hard strings like</p> <p>launcher "^<br> launcher ten^>one<br> launcher "&amp;"^&amp; </p> <pre><code>@echo off setlocal DisableDelayedExpansion set "prompt=X" for %%a in (1 ) do ( @echo on for %%b in (4) do ( rem #%1# ) ) &gt; XY.txt @echo off for /F "delims=" %%a in (xy.txt) DO ( set "param=%%a" ) setlocal EnableDelayedExpansion set param=!param:~7,-4! echo param='!param!' </code></pre> <p>How it works?<br> The only way I have found to expand %1 without expanding the special characters like " or ^ is in a REM statement (For REM that's not completly true, but that is an other story) Ok, the only problem is that a REM is a remark and has no effect :-) </p> <p>But if you use <strong>echo on</strong> also rem lines are echoed before they are executed (execute for rem is a nice word).<br> The next problem is that it is displayed and you can not redirect this <strong>debug output</strong> with the normal > debug.txt. This is also true if you use a for-loop. </p> <p>Ok, you can redirect the <strong>echo on</strong> output with a call like </p> <pre><code>echo on call :myFunc &gt; debug.txt </code></pre> <p>But if you call a function you can't access the %1 of the batch file anymore. </p> <p>But with a double for-loop, it is possible to activate the redirection for the debug output and it's still possible to access %1.<br> I change the prompt to "X", so I know it is always only one character long.</p> <p>The only thing left is to explain why I append a # to %1.<br> That's because, some special characters are recognized in some situations even in a REM line, obviously ;-) </p> <pre><code>rem This is a remark^ rem This_is_a_multiline^ rem "This is also a multiline"^ </code></pre> <p>So the # suppress a possible multiline situation.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to avoid cmd.exe interpreting shell special characters like < > ^
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USjeb
    1. USjeb
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAdding 'setlocal EnableDelayedExpansion' to the top of the CMD script unfortunately does not resolve the issue. For the second example, where we want to pass the parameter literal "^, it's still necessary for the user to double-escape the caret as shown.
      singulars
      1. PO
      1. USPaul Urban
    2. COOk, a <LF> can break this code, but it seems that other characters are working
      singulars
      1. PO
      1. USjeb
    3. COFantastic effort! I'm testing it, but it only seems to echo the first argument I pass to it?
      singulars
      1. PO
      1. USPaul Urban
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload