Narasiman nar

Narasiman nar

  • NA
  • 64
  • 22.5k

how to split string in to each column

May 22 2018 9:59 AM
 
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
 
 
     
  
 

Answers (5)