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 Mike Lewis 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
Mar 5, 2004
92
0
0
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
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
113
mmiah1982
mmiah1982
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
149
carp
carp
cristianivanoff
  • Locked
  • Question
Calculating amount from transactions...
Replies
1
Views
98
fredericofonseca
fredericofonseca
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
80
mikrom
mikrom
barnettjacob
  • Locked
  • Question
SQL Query - Summarise Data from 2nd table 2
Replies
8
Views
93
r937
r937

Part and Inventory Search

Sponsor

Back
Top