String Splits

Question

Post reply

String Splits

Fernando Zavala-428885

Newbie

Points: 2
More actions
May 12, 2008 at 1:03 pm

#182238

Hi, I have a column where i need to extract pieces of a name and display it in seperate row's. The name can contain salutations, as well as middle name and a suffix. Any ideas are welcomed.

Viewing 4 posts - 1 through 3 (of 3 total)

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

DAVNovak Hall of Fame Points: 3120 More actions · Answer 1

It would be helpful if you could provide some examples of the data and how you want the results to look.

Dave Novak

Fernando Zavala-428885 Newbie Points: 2 More actions · Answer 2

Thanks for the reply, but I just whipped something out, and it seems to be working just fine thanks for the post anyways.

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 3

Heh... two way street here... would you mind posting your solution, please? 😉

--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)