Post reply

dividing a single column into parts

  • October 22, 2009 at 11:16 am

    #211333

    Hi All,

    Is there any way to split this long string column separated by DOTS

    from source into severals columns in target

    For Ex:

    LONGcolumn

    ab.cd.ef.gh

    Target should be:

    Col1 Col2 Col3 Col4

    ab cd ef gh

    Thanks in Advance

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • October 22, 2009 at 11:23 am

    #1069569

    In SSIS, I would be tempted to use a script task and use the VB.Net split function splitting the columns into it's parts.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 22, 2009 at 11:26 am

    #1069570

    But I have to do it in a stored procude while selecting the source data,,Is it possible in a stored proc?

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • October 22, 2009 at 11:29 am

    #1069572

    Why are you posting this under SSIS if you have to do this in a stored procedure?


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 22, 2009 at 11:32 am

    #1069573

    Hi,

    this is really good resource: http://www.sqlservercentral.com/articles/T-SQL/62867/

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy