Regular Expressions 101

explore:the literal text explore: (case sensitive)

.*?any Unicode character, repeated any number of times

Positive Lookahead(?=explore|$)

1st Alternativeexplore

explorethe literal text explore (case sensitive)

2nd Alternative$

$end of string, or before its final line terminator

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

explore:.*?(?=explore|$)

New

explore: character_balance {}
explore: tower_ends {
  label: "Tower Results"
  join: activity_type {
      relationship: many_to_one
      type: inner
      sql_on: ${activity_type.activity_name}=${wba_fact_activity.activity_name} ;;
  }
}
explore: seven11_core_session_start {}

Regular Expression

Substitution