Parse specific strings in SQL Server

Question

I' ve got this string:

DealerCode = [MAZ3].AccountID:[4340].StartDate=[2015-06-01]

select parsename('DealerCode = [MAZ3].AccountID:[4340].StartDate=[2015-06-01]', 1)

and so on gives me null. How should i change my query to get values between dots?

@lgO , Do you only want 'AccountID:[4340]' to be returned or all 3 segments? — PKirby, Jul 17 '15 at 12:12
I wan to get DealerCode = [MAZ3] AccountID:[4340] StartDate=[2015-06-01] all 3 values apart — IgO, Jul 17 '15 at 12:15

score 2 · Accepted Answer · edited Jul 17 '15 at 12:28

2

Try this :

DECLARE @param NVARCHAR(MAX)
SET @param = 'DealerCode = [MAZ3].AccountID:[4340].StartDate=[2015-06-01]'

SELECT 
     Split.a.value('.', 'VARCHAR(100)') AS CVS  
FROM  
(
    SELECT CAST ('<M>' + REPLACE(@param, '.', '</M><M>') + '</M>' AS XML) AS CVS 
) AS A CROSS APPLY CVS.nodes ('/M') AS Split(a)

edited Jul 17 '15 at 12:28

Imran Ali Khan

8,469
16
52
77

answered Jul 17 '15 at 12:17

PKirby

859
3
16
36

1

Wow that was creative. Sorry for useless comment, but I felt the urge to applaud. – Raybarg Jul 17 '15 at 12:36

Parse specific strings in SQL Server

1 Answers1