~/talk

Regex in PowerShell: How to grasp it and why you should grasp it

Talkat SQLBits 2023 · 2023-03-14..03-18· [developer-experience, data-engineering]
links:none on file
slides:none on file

Deep dive into PowerShell regex with concrete outcomes: a single inline pattern captures UK postcodes across seven postcode rules and varied placements, a set of staged regexes replaces inconsistent UTC offsets without corrupting valid +00:00 values thus saved import by avoiding +000 corruption, and an automation extracts SQL/DAX/M block comments into OneNote using a while loop to force non‑greedy extraction plus Regex Match object properties to pull groups for further processing.

AI-written summary · about

  1. 0:00Introduction and background
  2. 2:44The case for learning regex
  3. 5:53Practical regex use cases
  4. 9:41Core principles of regex
  5. 12:29Special characters and syntax
  6. 17:31Advanced pattern matching
  7. 20:45Regex strategy and conclusion
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.