insert Regex trick at any step (mid?) Advanced Editor

[ooptennoort]

Trying to use run the Regex trick (that members Grah and Bo_Ry skillfully adapted for this case), I run into a problem which might have to with my worksheet not being a table. The error text is:

Expression.Error: The field 'Comment' of the record wasn't found.
Details:
Name=Sheet1
Data=

Item=Sheet1
Kind=Sheet
Hidden=FALSE


The Regex trick in this case was:

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Regex = Table.AddColumn(Source, "Regex", each Text.Combine(Json.Document(Web.Page(
"<meta http-equiv='X-UA-Compatible' content='IE=edge'> <script>
document.write(JSON.stringify('"& [Comment] &"'.match(/\d+[A-Z]-\d+-\d+/g)));
</script>")[Data]{0}[Children]{0}[Children]{1}[Text]{0}),", "))
in
Regex


My question:
Maybe if I'd simplify my workbook, convert to range etc. I could get the trick to work but... why not reach higher: can the Regex trick be altered to be inserted anywhere, at any step, in the Advanced Editor? If so, how? If not (most likely), could anyone pls direct me to literature where I can read why not (and maybe even learn to make a workaround)?