Regular Expressions 101

PIN#the literal text PIN# (case sensitive)

Non-Capturing Group(?: [A-Z0-9]*[0-9][A-Z0-9]*)*

*repeats the group contents below any number of times:

the literal (32₁₀ / 40₈ / 20₁₆)

Character Class[A-Z0-9]*

*matches any number of characters from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Character Class[0-9]

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Character Class[A-Z0-9]*

*matches any number of characters from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Global pattern flags

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

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

PIN#(?: [A-Z0-9]*[0-9][A-Z0-9]*)*

New

      df['description']
0.   PRAIRIE HIGHLANDS SIXTH PLAT Lt: 156 PIN# DP73770000 0156 312 ABC
1.   PRAIRIE VILLAGE   PIN# OP55000034 0020A Rmrk: PT OF
2.   Sub: HOLLY GREEN Lt: 14 Bl: 1 PIN# DP34500001 0D14
3.   FAIRWAY   PIN# GP20000006 0029 Rmrk: W

Regular Expression

Substitution