how to split string in to each column

8y809

Select REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Data,'[',''),']',''),'"',''),'',' '),',',' ') as Data from test

When i execute the above query i get output as follows

Data Columnname

What is your name Rajesh ---> Values

I want excepted ouput as follows

What is yourname Columnname

Rajesh ---> Values

for getting above output what changes i have to made. please let me know

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
You need to provide a screenshot of the data
we are not sure waht you are looking for , so please provide more information so that we can help
0
8y ago
i treid your as follows

SELECT farm_detailsdata
, RIGHT ([farm_detailsdata] , CHARINDEX (' ' , REVERSE([farm_detailsdata]), 0)-0) as name
FROM dbo.tbl_farmer_farmdetails_mozambique

farmdetaildata Name

{"Produto preferido para produção":"Algodão","Plantou algodão no ano passado?":"Sim","Irá plantar Algodão próximo ano?":"Não","Aumentará área de algodão no próximo ano?":"Nãoplantou"}

When i run the above query i get output as follows

Name
Nãoplantou"}

But i want the full text as metnioned above

in my above sql query what changes i have to made to get full text. i think Right keyword should not used.

which is the other way to use to get the full text.
0
Shahriar Nikkhah8y ago
this might help
DECLARE @tblXYZ AS TABLE
(   [id]            Int
,   [Data]          nVarChar(100)
)

INSERT INTO @tblXYZ
VALUES (1,'WHAT IS YOUR NAME Rajesh') , (2,'WHAT IS YOUR NAME Nik')


SELECT  *
    ,   RIGHT([data] , CHARINDEX (' ' , REVERSE([Data]), 1)-1)
FROM    @tblXYZ
0
8y ago
data is the column name of the table.

please help me. how to do.
0
Bryian Tan8y ago
what in the "Data"? Any example?
+1