Jump to content


Photo

How To Split Up Text In A Column


  • Please log in to reply
1 reply to this topic

#1 yoursurrogategod

yoursurrogategod

    Advanced Member

  • Members
  • PipPipPip
  • 179 posts

Posted 16 November 2012 - 09:19 AM

Hi, I have this piece of text that is stored in our MS-SQL database (ignore the quotes and no, I can't redesign how this work specifically):
"TEST|00000298398293|EQ5|Patient"

Now, when I do a simple select, I get that result being returned. What I'd like to do is split that string based on the "|" character and return the individual strings associated with this string, so that I could have "TEST", "0000298398293", "EQ5" and "Patient" in different fields. How can I do this? In PHP, you can use the explode method, is there something like that in MS-SQL?

#2 yoursurrogategod

yoursurrogategod

    Advanced Member

  • Members
  • PipPipPip
  • 179 posts

Posted 16 November 2012 - 10:42 AM

I found this solution elsewhere:

DECLARE @Sql varchar(50) = 'TEST|00000298398293|EQ5|Patient'

This only works if you have 3 pipes


SELECT PARSENAME(REPLACE(@sql,'|','.'),4)
,PARSENAME(REPLACE(@sql,'|','.'),3)
,PARSENAME(REPLACE(@sql,'|','.'),2)
,PARSENAME(REPLACE(@sql,'|','.'),1)






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com