Post reply

Extract only Numeric digits from the String -In SSIS -any transforamtion

  • June 22, 2010 at 7:23 am

    #234088

    Hi All,

    I have a column it contains a data say like

    "SO 90001415 4.000",

    "SO # 33199291 3.000 "

    "SO # SJ 20010883 17.000 "

    From this Column i need to extract only the Numeric Digit and put it in other column.

    How can i do this ,

    Thanks In Advance,

  • June 22, 2010 at 10:11 am

    #1183454

    Which one do you consider as a "numeric digit"?

    I see two valid numeric values in each row (e.g. 90001415 and 4.000 are both valid numeric values...). Is there a deterministic pattern within each string? For instance: always the first/second/middle/last value or value between -100 amd +100 or anything else?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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