SQL Server Performance

parsing address

Discussion in 'SQL Server DTS-Related Questions' started by gongxia649, Aug 2, 2006.

  1. gongxia649 New Member

    hi, im running into a bit of a problem. i will like to string parse the street name into what you see below using DTS. How can i get around this?

    12 north plaza boulevard apt.16

    12|N|plaza blvd| apt16
    gongxia649, Aug 2, 2006
    #2

  2. satya Moderator

    You can take help of GLobal variables in this case, refer to books online for more information.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
    satya, Aug 3, 2006
    #2

  3. Adriaan New Member

    Satya - what can you mean?
    Adriaan, Aug 3, 2006
    #2

  4. satya Moderator

    satya, Aug 3, 2006
    #2

  5. FrankKalis Moderator

    Since this is a DTS related question, I guess this is a better place for it. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>
    FrankKalis, Aug 3, 2006
    #2

  6. gongxia649 New Member

    12 north plaza boulevard apt.16

    i want to split the address and put it into multiple fields.
    address_number
    12

    suffixA
    North

    street_name
    plaza blvd

    suffixb
    apt16


    anyone can help?
    gongxia649, Aug 3, 2006
    #2

  7. Madhivanan Moderator

    Read about Parsename in sql server help file

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Aug 3, 2006
    #2

Share This Page