You can do this in two steps without wildcards

1. replace 'CSN' with 'CSN the'
2. replace 'the the' with 'the'


If you want to use a wildcard search

replace '(CSN)(![t])(![h])(![e])( )' with '/1 the' you'll need to look up the exact wildcard syntax.