Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Your code itself is correct; your regular expression isn't.</p> <p>Based on your comments on other answers, you're after a regular expression which matches any string which starts with A, and you're assuming that '<code>*</code>' means "any characters". '<code>*</code>' in fact means "match the preceding character zero or more times", so the regular expression you've given means "match the start of the string followed by zero or more 'A' characters", which will match absolutely anything.</p> <p>If you're looking for a regular expression that matches the whole string but only if it starts with 'A', the regular expression you're after is <code>^A.*</code>. The '<code>.</code>' character in a regular expression means "match any character". This regular expression thus means "match the start of the string, followed by an 'A', followed by zero or more other characters" and will thus match the entire string provided it starts with 'A'.</p> <p>However, you already <em>have</em> the whole string, so this is a little unnecessary - all you really want to do is get an answer to the question "does the string start with an 'A'?". A regular expression that will achieve this is simply '^A'. If it matches, the string started with an 'A'.</p> <p>Of course, it should be pointed out that you don't need a regular expression to confirm this anyway. If this is genuinely all you want to do (and it's possible you've just put together a simple example, and your real scenario is more complicated), why not just use the StartsWith method?:</p> <pre><code>bool match = actualValue.StartsWith("A"); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POC# regex match behaviour
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChris
    1. USChris
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POC# regex match behaviour
      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. VTAcceptedByOriginator
    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. COWhy not dump the /.*/ and stick to /^A/? /.*/ is a tautology as far as I can tell.
      singulars
      1. PO
      1. USOday Mansour
    2. CO@Oday Mansour what does every symbol in /^A/?/.*/ means? i just understand the dot '.' means anything so why not just "A." as a reg expression?
      singulars
      1. PO
      1. USYonatan Nir
    3. CO"^A" is what I'm proposing. I said that ".*" is a tautology because it will fit anything. "." means "any character" and "\*" means "0 or more times" so ".*" means "anything 0 or more times". "^A" means "A string that starts (^) with A (A)". The "?" here was for the question, not the regex. Also as a side note, some people are used to write regex patterns between / slashes so /^A/ is basically the regex pattern "^A".
      singulars
      1. PO
      1. USOday Mansour
 

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