Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think the difficulty is that the random text can also contain commas.</p> <p>If the keywords are all on one line and it is the last line of the text as a whole, trim the whole text removing new line characters from the end. Then take the text from the last new line character to the end. This should be your string containing the keywords. Once you have this part singled out, you can explode the string on comma and count the parts.</p> <pre><code>&lt;?php $string = " some gibberish, some more gibberish, and random text keyword1, keyword2, keyword3 "; $lastEOL = strrpos(trim($string), PHP_EOL); $keywordLine = substr($string, $lastEOL); $keywords = explode(',', $keywordLine); echo "Number of keywords: " . count($keywords); </code></pre> <p>I know it is not a regex, but I hope it helps nevertheless.</p> <p>The only way to find a solution, is to find something that separates the random text and the keywords that is not present in the keywords. If a new line is present in the keywords, you can not use it. But are 2 consecutive new lines? Or any other characters.</p> <pre><code>$string = " some gibberish, some more gibberish, and random text keyword1, keyword2, keyword3, keyword4, keyword5, keyword6, keyword7, keyword8, keyword9 "; $lastEOL = strrpos(trim($string), PHP_EOL . PHP_EOL); // 2 end of lines after random text $keywordLine = substr($string, $lastEOL); $keywords = explode(',', $keywordLine); echo "Number of keywords: " . count($keywords); </code></pre> <p>(edit: added example for more new lines - long shot)</p>
    singulars
    1. This table or related slice is empty.
    1. PORegex to match text between commas
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJeroen
    1. USJeroen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORegex to match text between commas
      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. VTAcceptedByOriginator
    1. COJust made an edit to the question to clarify that the random text has commas and all kind of special chars and the keywords are NOT in one line
      singulars
      1. PO
      1. USSkarXa
    2. COThen it is pretty hard to do unless you know of a way how the keywords are separated from the random text (even if it is by 2 end of lines, then you can use that as a start point
      singulars
      1. PO
      1. USJeroen
    3. CO@skarxa I updated my answer with a double line delimiter not present in keywords. if that is also not OK, I give up. :) you need a delimiter to separate between the 2
      singulars
      1. PO
      1. USJeroen
 

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