regex101: Golang Substitution Workspace

Pro

^start of line

FROM the literal text FROM (case sensitive)

Group 1(.{1})

.{1}any character (except for line terminators), repeated exactly 1 time

Group 2([\p{L}_][\p{L}\p{N}@$#_]{0,127})

Character Class[\p{L}_]

\p{L}any Unicode letter

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

Character Class[\p{L}\p{N}@$#_]{0,127}

{0,127}matches between 0 and 127 characters from the set below:

\p{L}any Unicode letter

\p{N}a decimal digit, letterlike number, or other numeric character

@the literal @ (64₁₀ / 100₈ / 40₁₆)

$the literal $ (36₁₀ / 44₈ / 24₁₆)

#the literal # (35₁₀ / 43₈ / 23₁₆)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

Group 3(.{1})

.{1}any character (except for line terminators), repeated exactly 1 time

Group 4(.*)

.*any character (except for line terminators), repeated any number of times

$end of line

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

25 tokens

Regular Expression

^FROM (.{1})([\p{L}_][\p{L}\p{N}@$#_]{0,127})(.{1})(.*)$

New

SELECT `e0`.`order_code`
FROM `ep_orders` AS `e`
-----^XXXXXXXXX^----^X^-- Is it possible capture this character without knowing the contents and length of X-sequence?
INNER JOIN `ep_orders` AS `e0` ON (`e`.`order_boek_code` = `e0`.`order_boek_code`) AND (`e`.`order_code` = `e0`.`order_code`)
WHERE `e`.`order_fase_bf` = `e0`.`order_fase_bf`

Substitution

FROM ${1}database_name$3.$3${2}$3$4

SELECT `e0`.`order_code`
FROM `ep_orders` AS `e`
-----^XXXXXXXXX^----^X^-- Is it possible capture this character without knowing the contents and length of X-sequence?
INNER JOIN `ep_orders` AS `e0` ON (`e`.`order_boek_code` = `e0`.`order_boek_code`) AND (`e`.`order_code` = `e0`.`order_code`)
WHERE `e`.`order_fase_bf` = `e0`.`order_fase_bf`