Home Forums Data Warehousing Integration Services Extract only numbers from string which contains special characters too RE: Extract only numbers from string which contains special characters too

  • mister.magoo (1/13/2013)


    And another Tally type version, but seems faster to me...

    That's solid. I meant to come back to this because using RANK seemed clunky and I knew there had to a better way. Thanks for refreshing my memory on the XML PATH technique to pivot the good chars back into a string without a delimiter. The method you showed is clearly a better solution than mine but it was a fun exercise nonetheless.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato