使用分隔符在SQL Server中分割字符串 [英] Spliting the string in SQL Server using a delimiter

问题描述

My string is as below :

<pre>'<SL1> Locationdetails are in the table .<RXCH><cF7712>Location1<cF4712>
            <RXCS1>H1<RXCS2>H2<RXCS3>H3
            <RXC11>C11<RXC12>C12
            <RXC13>C13<RXC21>C21
            <RXC22>C22<RXC23>C23
            <RXC31>C31<RXC32>C32
            <RXC33>C33<RXC41>C41
            <RXC42>C42<RXC43>C43
            <RXC51>C51<RXC52>C52
            <RXC53>C53
            <RXCH><cF7712>Location2<cF4712>
            <RXCS1>H1<RXCS2>H2<RXCS3>H3
            <RXC11>C11<RXC12>C12
            <RXC13>C13<RXC21>C21
            <RXC22>C22<RXC23>C23
            <RXC31>C31<RXC32>C32
            <RXC33>C33<RXC41>C41
            <RXC42>C42<RXC43>C43
            <RXC51>C51<RXC52>C52
            <RXC53>C53. Services for primary health care'

OUTPUT should be ::

'Location1 H1 H2 H3 C11 C12 C13 C21 C22 C23 C31 C32 C33 C41 C42 C43 C51 C52 C53 Location2 H1 H2 H3 C11 C12 C13 C21 C22 C23 C31 C32 C33 C41 C42 C43 C51 C52 C53'

推荐答案

请参阅
http://www.codeproject.com/Questions/620183/Split-string-function-in-Sql-Server

refer this
http://www.codeproject.com/Questions/620183/Split-string-function-in-Sql-Server

这篇关于使用分隔符在SQL Server中分割字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！