Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You are correct that it's a simple problem. In fact it is solved with the introduction of 4 characters, all the same one.</p> <p>Exposing a backslash in batch is a bad idea, it's likely to confuse the interpreter into thinking that it's dealing with an actual file or path. You should surround it with double-quotes. This is true with other characters, including !%&amp;*?/\&lt;>,. mostly special characters that deal with paths and files. There may be more, and some are only occasionally a problem. Even 1 and 2 can cause trouble when next to a redirection character.</p> <p>Just to let you know, neither <code>setlocal</code> or the delayed expansion notation <code>!</code> are necessary here, although there is no harm in it. (Except that the delayed notation makes debugging harder as it did in this case, by showing, when ECHO is On, the variable name rather than it's contents.)</p> <p>Also, when trimming the last character of a string you don't need 0 in <code>:~0,-1</code>, using <code>:~,-1</code> is sufficient. Though there is no harm in doing it either way.</p> <p>And lastly, the <code>echo on</code> is unnecessary, as <code>echo on</code> is the default. <code>Echo On</code> is more for just displaying small parts of the execution of a long file. Though, once again, there is no harm in it.</p> <pre><code>@echo on setLocal EnableDelayedExpansion ::set firstline to firstline of test.txt set /p firstline=&lt;test.txt ::Remove trailing slash if present ::Your error is below this IF "!firstline:~-1!"=="\" SET firstline=!firstline:~,-1! ::Output firstline (without \ to new txt file) echo !firstline!&gt;test2.txt endlocal </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PORemoving trailing backslash in a batch file
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJames K
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORemoving trailing backslash in a batch file
      singulars
      1. PTQuestion
    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. VTAcceptedByOriginator
    1. COThanks for the clarification James. However, when I test the file with test.txt (now listed in the original question), the trailing backslash is still not removed. Is there something else I am missing?
      singulars
      1. PO
      1. USJeff K
    2. CO@JeffK - You probably really have a trailing space on the end of that line. A result of doing this: `ECHO %stuff% > file` which looks nicer than `ECHO %stuff%> file`, but adds a space at the end of every line. In fact, you'll be adding __another__ additional space each time you run my code, if you use `echo !firstline! > test2.txt`, instead of `echo !firstline!>test2.txt`.
      singulars
      1. PO
      1. USJames K
    3. COYou're observation was correct, and I also solved this problem by using the following line (to account for the space): `IF "!firstline:~-2!"=="\" SET firstline=!firstline:~,-2!`. Thank you very much for the help, I appreciate it!
      singulars
      1. PO
      1. USJeff K
 

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