Remove unrecognised characters

Owned by Glen Epperson (Unlicensed)
Last updated: Nov 03, 2017 by Conor McCann
1 min read

Problem

This SQL removes any software in the software table where there are unrecognised characters in the name.

Solution

 

DELETE FROM PR_MapSoftwareProduct WHERE softwareid IN (SELECT SoftwareID FROM Software WHERE dbo.regexmatch([softwarename],'[^\u0009\u000a\u000d\u0020-\uD7FF\uE000-\uFFFD]',1)=1);

Filter by label

There are no items with the selected labels at this time.