I don't think senators write those files themselves.

It must be some IT department or a contractor hired to do the job.

Whoever they are working for - they must do their...

Yeah, why bother loading the correct data?

Main thing - the process does not report any errors.

The file has been built incorrectly.
No parsing tool can fix it.
Must be corrected at the source.

"NORTH DAKOTA STATE A"",""1",
"NORTH DAKOTA STATE ""A"" #1",
and so...

If you're trying to develop kinda schema-less database then SQL Server is obviously a wrong choice for the database engine.

You must use Unicode literal:

N'/' instead of '/'.

I assume, all columns and variables are defined as nvarchar, not varchar.

Maybe, I'm waiting for that?

😀

Apart from that- change all your literal constants from 'String' to N'String'

No-code platforms are basically interpreters from a human to the machine language.

To see how effective those things are copy this post to Google Translate and do double translation - say,...