EmbeddedSplit8K

  • Carlo Romagnano

    SSC-Insane

    Points: 21529

    Comments posted to this topic are about the item EmbeddedSplit8K

  • Sean Pearce

    SSCoach

    Points: 15750

    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: 21529

    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: 15750

    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: 16

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

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

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