Results 1 to 3 of 3

Thread: import question

  1. #1
    Join Date
    Jan 2004

    Unanswered: import question

    I have a excel comma seperated file with 2 columns.

    Column A contains names and Column B contains zips.

    The problem is Column A is not consistent in it's structure. Some columns only contain one name where others contain two names just by last name seperated by a space or a slash.

    For example


    I'm trying to clean the data before importing into a sql table. I want to seperate the records for column A where there are two names and move the second name to a new row. Is there a method to do this during the import? Or, within Excel prior to the import using replace? I want to find instances where there is a space or slash and move the name after the space or slash and move to a new row?


  2. #2
    Join Date
    Apr 2006
    I think in Excel you can do a text to column and put "/" or space as the delimitter

  3. #3
    Join Date
    Apr 2006
    Instead of leaning up just import the fist column in a temporary table and clean it by using substring and charindex.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts