Parse string in SQL Server

Question

I have string in format:

8:live:avishekh.bh 8:prakash.tndk 8:niraj.bajra

I want these in the format :

[live:avishekh.bh, prakash.tndk, niraj.bajra]

How could I achieve that in SQLServer?

TheGameiswar · Accepted Answer · 2018-04-05 12:04:21Z

2

You can use combination of stuff and replace:DEMO HERE

declare @string varchar(100)='8:live:avishekh.bh 8:prakash.tndk 8:niraj.bajra'

     select 
        '['+
        stuff(
        replace(@string,'8:',','),1,1,'')+']'

answered Apr 5, 2018 at 12:04

TheGameiswar

29k9 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JonWay · Accepted Answer · 2018-04-05 12:15:27Z

1

this should work

SELECT 
QUOTENAME(STUFF(REPLACE('8:live:avishekh.bh 8:prakash.tndk 8:niraj.bajra','8:',','),1,1,''))

QUOTENAME function is used for inserting square bracket in sql server

answered Apr 5, 2018 at 12:15

JonWay

1,7471 gold badge21 silver badges48 bronze badges

Collectives™ on Stack Overflow

Parse string in SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related