Regular Expressions 101

Group 1(datasource=\"([^"]*)\")

datasource=the literal text datasource= (case sensitive)

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

Group 2([^"]*)

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

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

Negative Lookahead(?!.+\1)

.+any character, repeated at least once

\1the text saved by group 1

Global pattern flags

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

s modifier: single line. Allows a dot to match line terminators

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(datasource=\"([^"]*)\")(?!.+\1)

New

  <cfquery name="qry_getEvent" datasource="#APPLICATION.firstDSN#">
    SELECT * 
    FROM events
    WHERE id = 1
  </cfquery>
  
    <cfquery name="qry_getPlayers" datasource="#APPLICATION.firstDSN#">
    SELECT * 
    FROM players
    WHERE event_id = 1
  </cfquery>
  
    <cfquery name="qry_getLocation" datasource="secondDSN">
    SELECT * 
    FROM locations
    WHERE event_id = 1
  </cfquery>

Regular Expression

Extraction