Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803

    I need a tool to break up my data. Help please

    Hello everyone, I have a record set with about 2000+ records that I need to insert into a db. One of the columns contains area codes WITH phone numbers formatted as such:
    Code:
    555-321-1212
    I have to break out the first 4 characters which would be the area code and the hyphen and move only the first 3 into another column. The hyphen will just get discarded.

    Is there a tool or some concept that someone can point me to so that I can complete this? I don't want to do this by hand. Thanks for the help. Frank

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i would use the SUBSTRING function in a query
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803
    Quote Originally Posted by r937
    i would use the SUBSTRING function in a query
    Rudy, your the best! Thanks!

Posting Permissions

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