EmbeddedSplit8K

Question

EmbeddedSplit8K

Carlo Romagnano

SSC-Insane

Points: 22599
More actions
November 26, 2018 at 1:01 pm

#380944

Comments posted to this topic are about the item EmbeddedSplit8K

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

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

Sean Pearce SSCoach Points: 15999 More actions · Answer 1

Yet another split function.....
While I do appreciate the effort, there are millions of these with extensive research on performance comparisons between the various options. This horse has been flogged to death.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Carlo Romagnano SSC-Insane Points: 22599 More actions · Answer 2

Sean Pearce - Thursday, December 6, 2018 6:31 AM
Yet another split function.....
While I do appreciate the effort, there are millions of these with extensive research on performance comparisons between the various options. This horse has been flogged to death.

EmbeddedSplit8K returns only chars delimited by two delimiter e.g. from the string 'Phone (123-45676) - Florida','(',')' returns only 123-45676

Sean Pearce SSCoach Points: 15999 More actions · Answer 3

Carlo Romagnano - Thursday, December 6, 2018 6:53 AM
Sean Pearce - Thursday, December 6, 2018 6:31 AM
Yet another split function.....
While I do appreciate the effort, there are millions of these with extensive research on performance comparisons between the various options. This horse has been flogged to death.
EmbeddedSplit8K returns only chars delimited by two delimiter e.g. from the string 'Phone (123-45676) - Florida','(',')' returns only 123-45676

Guess I didn't read it thoroughly enough. That's an interesting requirement though, surely that belongs in the presentation layer, although I suppose it may function in an ETL process. Why don't you write a little on how you are using this, it does sound interesting.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

zabavinv Grasshopper Points: 19 More actions · Answer 4

SELECT * FROM [dbo].[EmbeddedSplit8K]('ddd dd(d (12345) ee abcde)( ee )','(',')') --returns 12345 🙂