Monday, March 2, 2015

Handle the junk character

Try something like this. Maybe you can build a function for it?



DECLARE @in NVARCHAR(MAX) = N'µTorrent 3.3.1 Build 29938 Stable
µÛ¹úʱ´ú2Õ÷·þÕß ÖÐÎÄÓ²ÅÌ°æ
µÚÒ»´´ÒµÍøÉÏÐÐÇé½»Ò×ϵͳ
¶à¿Í·þ 4.4
¶àÃ×ÒôÀÖv5.1.1
“驱动魔法师网卡增强版安装包 V1.4.5.2 For Win98, Win2K, WinXP,
《Ryse:罗马之子》3DM简体中文硬盘版 版本 1.0
¶àÐãÊÓƵ 1.0.2.0', @out NVARCHAR(MAX) = N''

WHILE LEN(@in) > 0
BEGIN
IF ASCII(LEFT(@in,1)) BETWEEN 32 AND 127 AND (ASCII(LEFT(@in,1)) <> 63 OR LEFT(@in,1) = '?') BEGIN SET @out = @out + LEFT(@in,1) END
SET @in = RIGHT(@in,LEN(@in)-1)
END

SELECT @out





Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.


No comments:

Post a Comment