Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are some built-in functions that can clean up your code. And I think you're not leveraging the full power of regular expressions.</p> <p>The blaring issue here is <code>strsplit</code>. Comparing the equality of things character-by-character is inefficient when you have regular expressions. The pattern here uses the square bracket notation to filter for the characters you want. <code>*</code> is for any number of repeats (including zero), while the <code>^</code> and <code>$</code> symbols represent the beginning and end of the line so that there is nothing else there. <code>nchar(word)</code> is the same as <code>length(chars)</code>. Changing <code>&amp;&amp;</code> to <code>&amp;</code> makes the function vectorized so you can input a vector of strings and get a logical vector as output.</p> <pre><code>check.pattern.2 = function(word, min.size = 2) { word = trim(word) grepl(paste0("^[a-z!.?]*$"),word) &amp; nchar(word) &gt;= min.size } check.pattern.2(c(" d ","!hello ","nA!"," asdf.!"," d d ")) #[1] FALSE TRUE FALSE TRUE FALSE </code></pre> <p>Next, using curly braces for number of repetitions and some <code>paste0</code>, the pattern can use your min.size:</p> <pre><code>check.pattern.3 = function(word, min.size = 2) { word = trim(word) grepl(paste0("^[a-z!.?]{",min.size,",}$"),word) } check.pattern.3(c(" d ","!hello ","nA!"," asdf.!"," d d ")) #[1] FALSE TRUE FALSE TRUE FALSE </code></pre> <p>Finally, you can internalize the regex from <code>trim</code>:</p> <pre><code>check.pattern.4 = function(word, min.size = 2) { grepl(paste0("^\\s*[a-z!.?]{",min.size,",}\\s*$"),word) } check.pattern.4(c(" d ","!hello ","nA!"," asdf.!"," d d ")) #[1] FALSE TRUE FALSE TRUE FALSE </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POR code to check if word matches pattern
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBlue Magister
    1. USBlue Magister
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POR code to check if word matches pattern
      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. CONote that you accept word like `!!` here.
      singulars
      1. PO
      1. USagstudy
    2. COBe careful of `nchar(NA)` - it is 2!!
      singulars
      1. PO
      1. UShadley
    3. CO@agstudy That fits OP's pattern.
      singulars
      1. PO
      1. USBlue Magister
 

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