Can I ask why you are doing this rather than loading directly from the file to a table?

The exclamation mark and tilde are easy enough, but those square brackets are a challenge. I cheated by doing this:
WHERE REPLACE(REPLACE(w.SomeText, '[', ''), ']', '') LIKE...

Try changing your search string to this
'%[^-a-zA-Z0-9.&_#$\\() ]%'
I believe that the hyphen was causing you problems, because it is interpreted as a range separator, unless it occurs...

Please provide sample DDL and INSERTs for your data. I think you may need to expand on the summing logic you require too, as I do not understand it as...

Your suggested solution can be written more succinctly, like this:
DECLARE @YesNo BIT = 0;

SELECT
  A.name
,  A.married
FROM mytable A
WHERE A.married =...