regex101: Python Substitution Workspace

(?mi)applies the following effective flags to the remainder of the pattern: gmi

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Group 1((?:password=|user=)[^\n]*$|\<property key=\"variableNames\"\/\>\n|\<property key=\"variableValues\"\/\>\n)

1st Alternative(?:password=|user=)[^\n]*$

Non-Capturing Group(?:password=|user=)

1st Alternativepassword=

password=the literal text password= (case insensitive)

2nd Alternativeuser=

user=the literal text user= (case insensitive)

Negated Character Class[^\n]*

*matches any number of characters outside the set below:

\na line-feed (newline) character (ASCII 10)

$end of line

2nd Alternative\<property key=\"variableNames\"\/\>\n

\<the literal < (60₁₀ / 74₈ / 3C₁₆)

property key=the literal text property key= (case insensitive)

\"the literal " (34₁₀ / 42₈ / 22₁₆)

variableNamesthe literal text variableNames (case insensitive)

\"the literal " (34₁₀ / 42₈ / 22₁₆)

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

\>the literal > (62₁₀ / 76₈ / 3E₁₆)

\na line-feed (newline) character (ASCII 10)

3rd Alternative\<property key=\"variableValues\"\/\>\n

\<the literal < (60₁₀ / 74₈ / 3C₁₆)

property key=the literal text property key= (case insensitive)

\"the literal " (34₁₀ / 42₈ / 22₁₆)

variableValuesthe literal text variableValues (case insensitive)

\"the literal " (34₁₀ / 42₈ / 22₁₆)

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

\>the literal > (62₁₀ / 76₈ / 3E₁₆)

\na line-feed (newline) character (ASCII 10)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Search reference

Regular Expression

(?mi)((?:password=|user=)[^\n]*$|\<property key=\"variableNames\"\/\>\n|\<property key=\"variableValues\"\/\>\n)

New

<maplayer simplifyAlgorithm="0" minimumScale="0" maximumScale="2500" simplifyDrawingHints="0" readOnly="0" minLabelScale="0" maxLabelScale="1e+08" simplifyDrawingTol="1" geometry="Point" simplifyMaxScale="1" type="vector" hasScaleBasedVisibilityFlag="1" simplifyLocal="1" scaleBasedLabelVisibilityFlag="0">
      <id></id>
      <datasource>port=1521 user=test_user password=test_passwd</datasource>
      <keywordList>
        <value></value>
      </keywordList>
      <featformsuppress>0</featformsuppress>
      <editorlayout>generatedlayout</editorlayout>
      <widgets/>
      <conditionalstyles>
        <rowstyles/>
        <fieldstyles/>
      </conditionalstyles>
    </maplayer>
  </projectlayers>
  <properties>
    <Variables>
      <variableNames type="QStringList">
        <value>paswd</value>
        <value>user</value>
      </variableNames>
      <variableValues type="QStringList">
        <value>5zdgf</value>
        <value>dgdgdgfdg</value>
      </variableValues>
      </Variables>
    <customproperties>
    <property key="labeling/textColorR" value="0"/>
    <property key="labeling/textTransp" value="0"/>
    <property key="labeling/upsidedownLabels" value="0"/>
    <property key="labeling/useSubstitutions" value="false"/>
    <property key="labeling/wrapChar" value=""/>
    <property key="labeling/xOffset" value="0"/>
    <property key="labeling/yOffset" value="0"/>
    <property key="labeling/zIndex" value="0"/>
    <property key="variableNames"/>
    <property key="variableValues"/>
  </customproperties>

Regular Expressions 101

Regular Expression

Extraction