Databases
StackOverflow2013
Postsdbo
PORegEx to find specific URL structure
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORegEx to find specific URL structure
    primarykey
    data
    text
    <p>I have the following URLs</p> <pre><code>http://mysite/us/product.aspx http://mysite/de/support.aspx http://mysite/spaces/product-space http://mysite/spaces/product-space/forums/this is my topic http://mysite/spaces/product-space/forums/here is another topic http://mysite/spaces/support-zone http://mysite/spaces/support-zone/forums/yet another topic http://mysite/spaces/internal http://mysite/spaces/internal/forums/final topic http://mysite/support/product/default.aspx </code></pre> <p><strike>I want to add a Crawl Rule (This is SharePoint 2010 search related) using RegEx that excludes the URLs that don't include <code>/forums/*</code>, leaving only the forum topic URLs.</strike></p> <p>I want a rule that excludes the URLs for <code>../spaces/space1</code> and <code>../spaces/space2</code> but leaves all others intact, including the URLs containing <code>/forums/</code></p> <p>i.e. here are the results I want to identify with the regex (which will be used in an 'exclude' rule in SharePoint Search):</p> <pre><code>http://mysite/spaces/product-space http://mysite/spaces/support-zone http://mysite/spaces/internal </code></pre> <p>leaving these results not matched by the regex (and therefore not excluded by this rule)</p> <pre><code>http://mysite/us/product.aspx http://mysite/de/support.aspx http://mysite/spaces/product-space/forums/this is my topic http://mysite/spaces/product-space/forums/here is another topic http://mysite/spaces/support-zone/forums/yet another topic http://mysite/spaces/internal/forums/final topic http://mysite/support/product/default.aspx </code></pre> <p>Can someone help me out? I've been looking at this all morning and my head is starting to hurt - I can't explain it, I just don't get regular expression structures.</p> <p>Thanks</p> <p>Kevin</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USQMKevin
    1. USQMKevin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI was thinking something along the lines of: if URL contains /spaces/ AND there are only 4 forward slashes, then match the expression (and exclude those results). Not sure if that makes sense
      singulars
      1. PORegEx to find specific URL structure
      1. USQMKevin
    2. COJust so I'm sure I understand you correctly, should e.g. `http://mysite/spaces/space1/forums/here is another topic` be excluded or not? (contains `/forums/`)
      singulars
      1. PORegEx to find specific URL structure
      1. USrvalvik
    3. COCan you show what you want your output to look like (what will be returned)? Given what you're saying, I don't understand if, for example, `http://mysite/spaces/space2/forums/yet another topic` would be included since it matches the exclude AND include conditios you mention...
      singulars
      1. PORegEx to find specific URL structure
      1. USJohn Bustos
 

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