how to split string in to each column

Question

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

Bryian Tan · Answer

what in the "Data"? Any example?

Shahriar Nikkhah · Answer

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

Narasiman nar · Answer

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.

Shahriar Nikkhah · Answer

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

Narasiman nar · Answer

data is the column name of the table. please help me. how to do.