Article

Remove characters from a column

I needed to scrub a column of power meters. I needed to remove certain characters ( [space], hypens, / and . ) that had found their way into the system.

This was fast enough on a under a hundred thousand rows. You might want to try using CLR with RegEx if you have billions to clean.

Comments Closed.