Break string into SQL column regarding a specific character

Question

Break string into SQL column regarding a specific character

kakovatos7

SSC-Addicted

Points: 432
More actions
April 16, 2025 at 10:32 am

#4579826

Hi all,
I want to separate string within a table column, accordint to a specific character.
eg.
Field Value: test1,test2,test3,test4
Expected Result (break by character ","):
New Field
test1
test2
test3
test4
Any help?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

kakovatos7 SSC-Addicted Points: 432 More actions · Answer 1

explanation: I don't know the number of delimiter characters in each row (in my example, the character "," may have different number of occurences in each row).

kakovatos7 SSC-Addicted Points: 432 More actions · Answer 2

also, in each occurence of the character, I need a counter which will increase and show me for each record of the resultset which is the occurence sequense.

Ant-Green SSC Guru Points: 113536 More actions · Answer 3

Take a look at the delimitedsplit functions, do these do what you need.

https://www.sqlservercentral.com/forums/topic/using-the-delimitedsplit8k-function-help-jeff

Phil Parkin SSC Guru Points: 247156 More actions · Answer 4

DROP TABLE IF EXISTS #ToSplit;

CREATE TABLE #ToSplit
(
    SplitCol VARCHAR(8000) NOT NULL
);

INSERT #ToSplit
(
    SplitCol
)
VALUES
('test1,test2,test3,test4')
,('test5,test6');

SELECT ts.SplitCol
      ,ss.value
FROM #ToSplit ts
    CROSS APPLY STRING_SPLIT(ts.SplitCol, ',') ss;

ReidConley Newbie Points: 1 More actions · Answer 5

Use string split functions to separate by comma within the column.

Break string into SQL column regarding a specific character

Cookies on SQLServerCentral