Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden REPLACE Multiple Spaces with One RE: REPLACE Multiple Spaces with One

  • May 26, 2015 at 9:38 pm

    #1800736

    Alan.B (5/26/2015)

    Jeff Moden (5/26/2015)

    Alan.B (5/26/2015)

    I love this article Jeff and have been using your technique since I discovered this article a little more than a year ago.

    Thanks, Alan, but you need to revisit the article. Read the Prologue and see the first link there, which leads to Michael's method of using nested replaces just for the spaces. It blows the door off my method and virtually all comers. That's what I like about this community... lot's of people joined in the discussion and the result was a truly nasty fast method that passed my on the highway so fast that it looked like my method was standing still.

    I should start reading prologues I guess 😉

    Nonetheless, I tried the same exercise with Michael's function and the iTVF was about 25% faster still. Long live the inline scalar iTVF!

    Can't go wrong there. Guess I'm going to have to revisit this article. Heh... maybe add a pre-prologue. 😉

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