如何在Sql 2008中删除新行和一些特殊字符 [英] How Do I Remove New Line And Some Special Characters In Sql 2008
问题描述
在我的选择查询中,
i由于列而得到这个
141 CRTNS。
(仅限一个四分之一)
现成服装
女士长裙,配DUPATTA
发票编号:SSF / 55,56,57,58 / 14-15 DTD:02-06-2014
S / B编号:31166682,3116528,3120091,3120271 DT.04.06.2014
运费预付
现在我需要删除新线,使一切都成为一条线。
当我尝试时
SELECT Params =(SELECT REPLACE(REPLACE('141 CRTNS。
(ONE)仅限四件套)
现成服装
女士长裙配DUPATTA
发票编号:SSF / 55,56,57,58 / 14-15 DTD:02-06-2014
S / B编号:31166682,3116528,3120091,3120271 DT。 04.06.2014
FREIGHT PREPAID'+'=''',
CHAR(13),''),CHAR(10),'')
FOR
XML PATH(''),TYPE
).value('。[1]', 'nvarchar(max)');
i我用单行获取它但问题是我需要删除那些特殊字符(
),我认为是因为xml路径
我尝试过替换和所有的东西。请帮助我,请不要分享他的链接。
在这里你去 -
从SQL Server中的数据中删除NewLine字符 [ ^ ]
如何使用SQL从字符串中删除换行符? [ ^ ]
最后我想出了这个。从而解决了我的问题
SELECT ( CONVERT ( NVARCHAR ( 2000 ),东西(
(
选择 ' ;' + IsNull(cargo_description,' ')
从 BL_Configuration_Cargo_Description WHERE bl_configuration_id = @ bl_configuration_id
用于 Xml路径(' '), type
) .value(' 。',' nvarchar(max)')
, 1 , 2 ,' '跨度>))))
Hi in my select query ,
i am getting this as a result of a column
141 CRTNS.
(ONE FOURTY ONE CTNS ONLY)
READYMADE GARMENTS
WOMENS WOVEN LONG DRESS WITH DUPATTA
INVOICE NO.:SSF/55,56,57,58/14-15 DTD: 02-06-2014
S/B NO.:3116682,3116528,3120091,3120271 DT.04.06.2014
"FREIGHT PREPAID"
Now i need to remove the new line and make everything as a single line.
When i tried
SELECT Params = ( SELECT REPLACE(REPLACE('141 CRTNS.
(ONE FOURTY ONE CTNS ONLY)
READYMADE GARMENTS
WOMENS WOVEN LONG DRESS WITH DUPATTA
INVOICE NO.:SSF/55,56,57,58/14-15 DTD: 02-06-2014
S/B NO.:3116682,3116528,3120091,3120271 DT.04.06.2014
"FREIGHT PREPAID"' + ' = ''' ,
CHAR(13), ''), CHAR(10), '')
FOR
XML PATH(''), TYPE
).value('.[1]', 'nvarchar(max)');
i am getting it in single line but the problem is i need to remove that special characters(
), i think it is because of xml path
I have tried replace and all the things. Please help me, and please don't share he links.
Here you go -
Remove NewLine characters from the data in SQL Server [^]
How to remove new line character from string using SQL ?[^]
Finally i came up with this. And thus solved my problem
SELECT (CONVERT(NVARCHAR(2000), Stuff( ( Select '; ' + IsNull( cargo_description, '' ) From BL_Configuration_Cargo_Description WHERE bl_configuration_id=@bl_configuration_id For Xml Path(''), type ).value('.', 'nvarchar(max)') , 1, 2, ''))))
这篇关于如何在Sql 2008中删除新行和一些特殊字符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!