Split function in SQL Server 2005

Question

I have a string like val1_val2,val3_val4 and I need to split these values to tabled data as follows.

column1 column2
 Val1     val2 
 Val3     val4

Thanks in advance....

Simple, question and requirement thats it. What you have tried?? — Sai Kalyan Kumar Akshinthala, Mar 30 '12 at 10:12
@rizwanShahid, StackOverflow is a community where English is the lingua franca since it's about IT, so please, let's stick with it — Adrian Iftode, Mar 30 '12 at 10:20
does val1_val2 have the same pattern, isn't there a val3, val4, etc? — Adrian Iftode, Mar 30 '12 at 10:21
@Sai Kalyan Akshinthala: I tried to add my script, but its giving error, that why I didn't post my script here. Anyway Thank you. — Rajesh P, Mar 30 '12 at 10:49

score 3 · Accepted Answer · edited May 23 '17 at 11:56

3

A split function can be found here

declare @str varchar(100) 
set @str = "val1_val2,val3_val4"


declare @str varchar(100) = 'val1_val2,val3_val4'

select substring(f.value, 0, charindex('_', f.value)) as val1
      ,substring(f.value, charindex('_', f.value) + 1, LEN(f.value) ) as val2
from dbo.fnSplitString(@str, ',') f

edited May 23 '17 at 11:56

Community

1
1

answered Mar 30 '12 at 10:28

Adrian Iftode

15,465
4
48
73

Hey, you gave very smart answer for me.. Thank you. – Rajesh P Mar 30 '12 at 10:41

score 0 · Answer 2 · answered Mar 30 '12 at 10:20

0

There is a nice answer here:

http://www.codeproject.com/Articles/7938/SQL-User-Defined-Function-to-Parse-a-Delimited-Str

Using this function you could just use:

SELECT fn_ParseText2Table 'val1_val2,val3_val4', '_'

answered Mar 30 '12 at 10:20

Darren

68,902
24
138
144

Split function in SQL Server 2005

2 Answers2