Skip to content

Instantly share code, notes, and snippets.

@JiCiT

JiCiT/RegEx.md

Created May 31, 2022 21:04
Show Gist options
  • Save JiCiT/03f74312fceb5471a29aa1f792d23046 to your computer and use it in GitHub Desktop.
Save JiCiT/03f74312fceb5471a29aa1f792d23046 to your computer and use it in GitHub Desktop.
Download ZIP
Useful Regular Expressions
Raw
RegEx.md

SQL

Replace <Column> = <Expression>, -- <Comment> with , <Expression> AS <Colmun> -- <Comment>
Search Expression Replacement Expression
^(\s+,?)(.?)=(.?)(?:,\s*)?(--.*)?$ $1 $3 AS $2 $4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment