Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing extra commas from csv import

Status
Not open for further replies.
Wallie12

Wallie12

MIS
Joined
Mar 5, 2004
Messages
92
Location
US
Hello;
I am taking in a Oracle database with tables that have columns that have additional commas and I do not have at present time a way to edit the import csv's. Does anyone have an idea of how to work around this?

Thanks
Brian Mahler
Brianmahler@msn.com
 
Sort by date Sort by votes
this isn't really an ANSI SQL question

may i suggest that you post this question in the appropriate oracle forum?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmiah1982
  • Locked
  • Question Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
563
mmiah1982
mmiah1982
fredong
  • Locked
  • Question Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
827
carp
carp
cristianivanoff
  • Locked
  • Question Question
Calculating amount from transactions...
Replies
1
Views
533
fredericofonseca
fredericofonseca
mikrom
  • Locked
  • Question Question
from a table with symmetric relation select every pair only once
Replies
0
Views
439
mikrom
mikrom
barnettjacob
  • Locked
  • Question Question
SQL Query - Summarise Data from 2nd table
Replies
8
Views
588
r937
r937

Part and Inventory Search

Sponsor

Back
Top