Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'll bet there's another way to do this, but my first thought was <strong>gsubfn</strong>:</p> <pre><code>my_repl &lt;- function(x){ switch(x,a = "[this was an a]", b = "[this was a b]", c = "[this was a c]", z = "[this was a z]") } library(gsubfn) start_string &lt;- sample(letters[1:10], 10) gsubfn("a|b|c|z",my_repl,x = start_string) </code></pre> <p>If the patterns you are search for a acceptably valid names for list elements, this will also work:</p> <pre><code>names(my_replacement) &lt;- my_pattern gsubfn("a|b|c|z",as.list(my_replacement),start_string) </code></pre> <p><strong>Edit</strong></p> <p>But frankly, if I really had to do this a lot in my own code, I would probably just do the <code>for</code> loop thing, wrapped in a function. Here's a simple version using <code>sub</code> and <code>gsub</code> rather than the functions from <strong>stringr</strong>:</p> <pre><code>vsub &lt;- function(pattern,replacement,x,all = TRUE,...){ FUN &lt;- if (all) gsub else sub for (i in seq_len(min(length(pattern),length(replacement)))){ x &lt;- FUN(pattern = pattern[i],replacement = replacement[i],x,...) } x } vsub(my_pattern,my_replacement,start_string) </code></pre> <p>But of course, one of the reasons that there isn't a built-in function for this that's well known is probably that sequential replacements like this can't be pretty fragile, because they are so order dependent:</p> <pre><code>vsub(rev(my_pattern),rev(my_replacement),start_string) [1] "i" "[this w[this was an a]s [this was an a] c]" [3] "[this was an a]" "g" [5] "j" "d" [7] "f" "[this w[this was an a]s [this was an a] b]" [9] "h" "e" </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POAvoid for loop in string replacement?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USjoran
    1. USjoran
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAvoid for loop in string replacement?
      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, that definitely avoids the loop (so satisfies all my mentioned criteria), but in the real case I've got enough patterns and replacements (nothing huge, just 15 or so) that I'd rather not write them all in a switch statement.
      singulars
      1. PO
      1. USGregor
    2. CO@shujaa There are other options, but only if the search strings are allowable as list item names (see my edit).
      singulars
      1. PO
      1. USjoran
 

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