Results 1 to 4 of 4

Thread: cleansing data

  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Unanswered: cleansing data

    I have a table with 1.5 million rows. Each field has a text qualifier of " ". Could you please tell me if and how I can write a script to remove the quotes from each field?

    Thank you.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Using which database engine? The string operations aren't very standard between engines, so which engine makes a considerable difference.

    -PatP

  3. #3
    Join Date
    Nov 2004
    Posts
    2
    Using MS SQL Server 2000

  4. #4
    Join Date
    Oct 2003
    Posts
    357
    Hi mary10k, try this
    Code:
    update tablename set filedname=replace(filedname,""" ""","")
    Madhivanan

Posting Permissions

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