Click here to Skip to main content
15,891,316 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
input
Name raj mani bala ram





output
Name
raj
mani
bala
ram
Posted
Updated 30-Jul-14 18:06pm
v2
Comments
Magic Wonder 1-Aug-14 1:56am    
Good, you are already getting the required output.

If you are using SQL Server, try this:

DECLARE @TXT_TO_PARSE VARCHAR(MAX) = 'Name raj mani bala ram'
; WITH SRC_TXT AS (
/*This CTE replaces line feeds with a Space*/
SELECT REPLACE(REPLACE(@TXT_TO_PARSE,CHAR(13),' '),CHAR(10),' ')+' ' AS TXT
),
/*The Following CTE recursively loops through all the Tokens in the string*/
TOKENISE AS (
SELECT
CAST(TXT AS VARCHAR(MAX)) AS TXT
,CAST(NULL AS VARCHAR(MAX)) AS TOKEN
,CAST(1 AS INTEGER) AS PTR
FROM SRC_TXT
UNION ALL
SELECT TXT
,CAST(RTRIM(LTRIM(SUBSTRING(TXT,PTR,CHARINDEX(' ',TXT,PTR+1)-PTR))) AS VARCHAR(MAX)) AS TOKEN
,CAST(CHARINDEX(' ',TXT,PTR+1) AS INTeger) AS PTR
FROM TOKENISE
WHERE CHARINDEX(' ',TXT,PTR+1)-PTR > 0
)
SELECT TOKEN
FROM TOKENISE
WHERE TOKEN IS NOT NULL AND TOKEN!=' '

Hope this works
 
Share this answer
 
 
Share this answer
 
 
Share this answer
 
There are lots of split functions on google. You can use any of them.
One of them is in the below link.

Split function in SQL[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900