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); |
Related articles
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | ~Glen.Epperson |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label = "kb-troubleshooting-article" and type = "page" and space = "~Glen.Epperson" |
|---|
| labels | kb-troubleshooting-article |
|---|
|
