regex101: JavaScript Match Workspace

Group 1('.{1,31}'|[\w.]{1,31}?)

1st Alternative'.{1,31}'

'the literal ' (39₁₀ / 47₈ / 27₁₆)

.{1,31}any character (except for line terminators), repeated between 1 and 31 times

'the literal ' (39₁₀ / 47₈ / 27₁₆)

2nd Alternative[\w.]{1,31}?

Character Class[\w.]{1,31}?

{1,31}?matches between 1 and 31 characters from the set below:

\wany word character

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

!the literal ! (33₁₀ / 41₈ / 21₁₆)

Group 2(([\w$].*?):([\w$]*)|([\w$].*))

1st Alternative([\w$].*?):([\w$]*)

Group 3([\w$].*?)

Character Class[\w$]

\wany word character

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

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

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Group 4([\w$]*)

Character Class[\w$]*

*matches any number of characters from the set below:

\wany word character

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

2nd Alternative([\w$].*)

Group 5([\w$].*)

Character Class[\w$]

\wany word character

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

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

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

26 tokens

Regular Expression

('.{1,31}'|[\w.]{1,31}?)!(([\w$].*?):([\w$]*)|([\w$].*))

New

=(PAM_EXTRACT.BRS_HLD.FTH.L.BLK.2!A290:A290)

t'#3cfbsdjfdsjb''''''''^^^^^^&&'!$C$8:$N$23   

1'!$E$13:$H$19   // Invalid sheet name

!'!$B$7:$E$16   // Invalid sheet name 

@@@@@@@'!$B$7:$K$21 // Invalid sheet name

!$'!$B$12:$M$17 // Invalid sheet name

t'#3cfbsdjfdsjb''''''''^^^^^^&&'!$C$8:$N$23,p,mv

sheeet1!$A1

=IFERROR(IF(AND(EXACT('cwReport 12-31-2018'!A965:A965, 'cwReport 12-31-2018'!A1185:A1185),EXACT('cwReport 12-31-2018'!A1185:A1185, PAM_EXTRACT.BRS_HLD.FTH.L.BLK.2!A1371:A1371)), 0, 1), 1)

=SUM('(A(very_bad)sheet_name'!A1:B1)

Extraction

=(PAM_EXTRACT.BRS_HLD.FTH.L.BLK.2!A290:A290)

t'#3cfbsdjfdsjb''''''''^^^^^^&&'!$C$8:$N$23   

1'!$E$13:$H$19   // Invalid sheet name

!'!$B$7:$E$16   // Invalid sheet name 

@@@@@@@'!$B$7:$K$21 // Invalid sheet name

!$'!$B$12:$M$17 // Invalid sheet name

t'#3cfbsdjfdsjb''''''''^^^^^^&&'!$C$8:$N$23,p,mv

sheeet1!$A1

=IFERROR(IF(AND(EXACT('cwReport 12-31-2018'!A965:A965, 'cwReport 12-31-2018'!A1185:A1185),EXACT('cwReport 12-31-2018'!A1185:A1185, PAM_EXTRACT.BRS_HLD.FTH.L.BLK.2!A1371:A1371)), 0, 1), 1)

=SUM('(A(very_bad)sheet_name'!A1:B1)