Regular Expressions 101

Explanation

Pro

AS "the literal text AS " (case sensitive)

Group 1(.+)

.+any character (except for line terminators), repeated at least once

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Group 2(.+)

.+any character (except for line terminators), repeated at least once

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

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

AS "(.+)\.(.+)"

New

	table1.field1 AS "table1.field1",
	table2.field2 AS "table2.field2",
	table3.field3 AS "table3.field3",
	table4.field1 AS "table4.field1",
	table4.field1 AS "table5.field5",
	table6.field6 AS "table6.field1",

Substitution

	table1.field1 AS "table1.field1",
	table2.field2 AS "table2.field2",
	table3.field3 AS "table3.field3",
	table4.field1 AS "table4.field1",
	table4.field1 AS "table5.field5",
	table6.field6 AS "table6.field1",