Parse data

Question

Parse data

oradbguru

Hall of Fame

Points: 3126
More actions
January 18, 2012 at 7:02 am

#266892

Hello, I am trying to parse data and put in seperate columns if possible. For example:
332|347
348|332|342|343
I want to have:
col1 col2 col3 col4
332 347
348 332 342 343

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

Jeff Moden wrote an excellent article that does exactly what you need. Click this link --> http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Jeff Moden SSC Guru Points: 1004280 More actions · Answer 2

oradbguru (1/18/2012)
Hello, I am trying to parse data and put in seperate columns if possible. For example:
332|347
348|332|342|343
I want to have:
col1 col2 col3 col4
332 347
348 332 342 343

Does the actual data have the Pipe symbols in it? Also, since you're relatively new to the forum, take a look at the first link in my signature line below for how to get coded answers to your questions. Thanks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

oradbguru Hall of Fame Points: 3126 More actions · Answer 3

Jeff, yes the pipes are in the data. Thank you for the link as well!

Jeff Moden SSC Guru Points: 1004280 More actions · Answer 4

Just checking. Are you all set on this or do you need more help?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

oradbguru Hall of Fame Points: 3126 More actions · Answer 5

oradbguru

Hall of Fame

Points: 3126

February 5, 2012 at 4:07 pm

#1442865

I am all set Jeff. Thank you!

David