Databases
StackOverflow2013
Postsdbo
POpython regex, substitute patterns in a string
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POpython regex, substitute patterns in a string
    primarykey
    data
    text
    <p>I want to replace some substrings in a string with wiki markup. E.g. I have a string</p> <pre><code>some other string before ; Methods {{columns-list|3| * [[Anomaly detection|Anomaly/outlier/change detection]] * [[Association rule learning]] * [[Statistical classification|Classification]] * [[Cluster analysis]] * [[Decision trees]] * [[Factor analysis]] * [[Neural Networks]] * [[Regression analysis]] * [[Structured data analysis (statistics)|Structured data analysis]] * [[Sequence mining]] * [[Text mining]] }} ; Application domains {{columns-list|3| * [[Analytics]] * [[Bioinformatics]] * [[Business intelligence]] * [[Data analysis]] * [[Data warehouse]] * [[Decision support system]] * [[Drug Discovery]] * [[Exploratory data analysis]] * [[Predictive analytics]] * [[Web mining]] }} some other string after </code></pre> <p>I want to replace the original substring by</p> <pre><code>[[Anomaly detection|Anomaly/outlier/change detection]] [[Association rule learning]] [[Statistical classification|Classification]] [[Cluster analysis]] [[Decision trees]] [[Factor analysis]] [[Neural Networks]] [[Regression analysis]] [[Structured data analysis (statistics)|Structured data analysis]] [[Sequence mining]] [[Text mining]] [[Analytics]] [[Bioinformatics]] [[Business intelligence]] [[Data analysis]] [[Data warehouse]] [[Decision support system]] [[Drug Discovery]] [[Exploratory data analysis]] [[Predictive analytics]] [[Web mining]] </code></pre> <p>I've tried some regex expressions to extract stuff in {{ }} first. But I always got None. </p> <p>ADD: The problem is that I'm only interested in the contents in [[]] which itself is in {{}}. I have some other occurrences of [[]] in other part of the string. </p> <p>So, how could I do this by using re.sub? Thanks</p> <p>ADD: current solution (ugly)</p> <pre><code>def regt(matchobj): #store matchobj.group(0) somewhere else, later on add them to the string #Next, another function will remove all {{}} alway return '' matches = re.sub(r'\[\[.*?\]\](?=[^{]*\}\})', regt,wiki_string2) </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USxuan
    1. USxuan
    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
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COUse [wiki parsers](http://www.mediawiki.org/wiki/Alternative_parsers)! Regex are meant for regular languages.
      singulars
      1. POpython regex, substitute patterns in a string
      1. USJBernardo
    2. COI tried re.sub(r'{{.*?}}', ' ', string), re.sub(r'\{\{.*?\}\}', ' ', string) and other more complicated re expressions I found online. I got the full string back.
      singulars
      1. POpython regex, substitute patterns in a string
      1. USxuan
    3. COHi JBernardo. Currently, I'm able to remove most wiki markups from the article. In my parser, I remove every occurrence of {{}}. I hope I could keep the contents in the tables. I found some wiki parsers online but these parsers only turn the wiki markups to html.
      singulars
      1. POpython regex, substitute patterns in a string
      1. USxuan
 

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