November 15, 2007 at 10:45 am
I have about 103,987 rows that are all full with double quotes. Example is "ABCD". I have 21 columns all together. How do eliminate these double quotes from "ABCD" to just ABCD instead. Urgent help needed.
[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]
November 15, 2007 at 12:23 pm
With a derivated column and replace function !!!
For each column, replace(columname,""","")
November 15, 2007 at 8:27 pm
Thank you,
I used an Update statment and replace to remove "".
Managed to solve it !
[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
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