Regular Expressions 101

\ban ASCII word boundary

Group 1(t(?:\w{4})\d{3})

tthe literal t (116₁₀ / 164₈ / 74₁₆) (case sensitive)

Non-Capturing Group(?:\w{4})

\w{4}any word character, repeated exactly 4 times

\d{3}a digit, repeated exactly 3 times

\ban ASCII word boundary

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

\b(t(?:\w{4})\d{3})\b

New

SELECT tcmcs003.*, tccom130.nama, tccom705.dsca, tcmcs052.dsca, tccom100.nama 
FROM tcmcs003, tccom130,tccom705,tcmcs052,tccom100 
WHERE tcmcs003.cadr REFERS TO tccom130 
 AND tcmcs003.casi REFERS TO tccom705 
 AND tcmcs003.cprj REFERS TO tcmcs052 
 AND tcmcs003.bpid REFERS TO tccom100 
ORDER BY tcmcs003._index1

Substitution

$1XXX