Databases
StackOverflow2013
Postsdbo
POHow to write this regular expression?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to write this regular expression?
    text
    copied!<p>This is a sample piece from a huge file containing formula and bio code. Some lines <strong>starts with</strong> the following characters: </p> <pre><code>Sheep"-head`ed, // followed by some normal words Mon`o*car*bon"ic, // followed by some normal words mon`o*car"di*an, // followed by some normal words Pol`y*chro"mate, // followed by some normal words sheep"cot`, // followed by some normal words baad, // followed by some normal words </code></pre> <p>I am new in regular expression. Now I am trying to use TPerlRegEx (<a href="http://www.regular-expressions.info/delphi.html" rel="nofollow">a wrapper of PCRE library</a>). I need to extract:</p> <pre><code>Sheep"-head`ed, Mon`o*car*bon"ic, mon`o*car"di*an, Pol`y*chro"mate, sheep"cot`, baad, </code></pre> <p>Can you help me write a regular expression?</p> <p>Many thanks.</p> <p>Edit: </p> <p>Thank all for help. If a normal is between them: </p> <pre><code>Sheep"-head`ed, // followed by some normal words Mon`o*car*bon"ic, // followed by some normal words New test, //I do not want two or more than two words that end with comma. mon`o*car"di*an, // followed by some normal words Pol`y*chro"mate, // followed by some normal words sheep"cot`, // followed by some normal words baad, // I want this one word that ends with comma </code></pre> <p>I still want: </p> <pre><code>Sheep"-head`ed, Mon`o*car*bon"ic, mon`o*car"di*an, Pol`y*chro"mate, sheep"cot`, baad, // I want this ONE word that ends with comma. </code></pre> <p>Thank you again.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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