Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you can modify the string:</p> <pre><code>// Note: This function returns a pointer to a substring of the original string. // If the given string was allocated dynamically, the caller must not overwrite // that pointer with the returned value, since the original pointer must be // deallocated using the same allocator with which it was allocated. The return // value must NOT be deallocated using free() etc. char *trimwhitespace(char *str) { char *end; // Trim leading space while(isspace((unsigned char)*str)) str++; if(*str == 0) // All spaces? return str; // Trim trailing space end = str + strlen(str) - 1; while(end &gt; str &amp;&amp; isspace((unsigned char)*end)) end--; // Write new null terminator character end[1] = '\0'; return str; } </code></pre> <p>If you can't modify the string, then you can use basically the same method:</p> <pre><code>// Stores the trimmed input string into the given output buffer, which must be // large enough to store the result. If it is too small, the output is // truncated. size_t trimwhitespace(char *out, size_t len, const char *str) { if(len == 0) return 0; const char *end; size_t out_size; // Trim leading space while(isspace((unsigned char)*str)) str++; if(*str == 0) // All spaces? { *out = 0; return 1; } // Trim trailing space end = str + strlen(str) - 1; while(end &gt; str &amp;&amp; isspace((unsigned char)*end)) end--; end++; // Set output size to minimum of trimmed string length and buffer size minus 1 out_size = (end - str) &lt; len-1 ? (end - str) : len-1; // Copy trimmed string and add null terminator memcpy(out, str, out_size); out[out_size] = 0; return out_size; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow do I trim leading/trailing whitespace in a standard way?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDave Gray
    1. USAdam Rosenfield
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I trim leading/trailing whitespace in a standard way?
      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. VTUpMod
    1. COSorry for the bad wording; I've edited it to add a solution for when you can't modify the string in-place
      singulars
      1. PO
      1. USAdam Rosenfield
    2. COYou should mention that you have to keep a copy of the original pointer in the first example when the string is malloc'ed, or you will never be able to free it again.
      singulars
      1. PO
      1. USjkramer
    3. COSorry, the first answer isn't good at all unless you don't care about memory leaks. You now have two overlapping strings (the original, which has it's trailing spaces trimmed, and the new one). Only the original string can be freed, but if you do, the second one points to freed memory.
      singulars
      1. PO
      1. USDavid Nehme
 

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