Computing.Net > Forums > Programming > deleting extra Character from colum

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

deleting extra Character from colum

Reply to Message Icon

Name: mailme_anil
Date: January 3, 2005 at 07:22:44 Pacific
OS: Unix
CPU/Ram: 1GB
Comment:

Hi,

I have a table in which all the columns have ' " '(double qoutes) at the beginning and the end. I want to remove these double quotes from the columns. All the columns are Varchar columns. How can I do this in Oracle or Teradata.
Ex:
I have the colmuns as:
"123","abc","Y"...

I need the columns as:
123,abc,Y...

Thanks,
Anil



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: deleting extra Character from colum

delete first three characters from each line www.computing.net/answers/programming/delete-first-three-characters-from-each-line/20245.html

batch delete x chars from txt file www.computing.net/answers/programming/batch-delete-x-chars-from-txt-file/16438.html

i keep getting extra characters www.computing.net/answers/programming/i-keep-getting-extra-characters/2046.html