Home » RDBMS Server » Server Utilities » second enclosure string not found
second enclosure string not found [message #278345] |
Sat, 03 November 2007 03:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shashwat
Messages: 3 Registered: November 2007
|
Junior Member |
|
|
we are using a comma delimited excel file as input, optionally enclosed by '"'. if one field contains data with comma enclosed within double quotes eg "nigdi chauk, pune" then there is a error because of comma after chauk, how to remove dat error
|
|
|
|
Re: second enclosure string not found [message #278351 is a reply to message #278346] |
Sat, 03 November 2007 03:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shashwat
Messages: 3 Registered: November 2007
|
Junior Member |
|
|
create table temporary_orders
(
OrderId number,
OrderDate Date,
RequiredDate date,
ShippedDate date,
Shipvia number,
Freight number,
ShipName varchar(40),
ShipAddress varchar(60),
Shipcity varchar(15),
ShipRegion varchar(15),
ShipPostalCode varchar(10),
ShipCountry varchar(15),
LastName varchar(20),
FirstName varchar(10),
Title varchar(30),
TitleOfCourtesy varchar(25),
BirthDate date,
HireDate date,
EmpAddress varchar(60),
EmpCity varchar(15),
EmpRegion varchar(15),
EmpPostalcode varchar(10),
EmpCountry varchar(15),
Homephone varchar(24),
Extension varchar(5),
Photo varchar(100),
Notes varchar(100),
ReportsTo number,
CustomerID varchar(5),
CompanyName varchar(40),
ContactName varchar(30),
ContactTitle varchar(30),
CusAddress varchar(60),
CusCity varchar(15),
CusRegion varchar(10),
CusPostalCode varchar(10),
CusCountry varchar(15),
CusPhone varchar(24),
CusFax varchar(24),
ShipperCompanyName varchar(40),
ShipperPhone varchar(24)
)
/
-- Copyright (c) 1991 by Oracle Corporation
-- NAME
-- ulcase3.ctl - <one-line expansion of the name>
-- DESCRIPTION
-- <short description of component this file declares/defines>
-- RETURNS
--
-- NOTES
-- <other useful comments, qualifications, etc.>
-- MODIFIED (MM/DD/YY)
-- cheigham 08/28/91 - Creation
--
-- $Header: ulcase3.ctl,v 1.1 1991/09/02 14:52:19 CHEIGHAM Stab $ case3.ctl
--
-- Variable length, delimited and enclosed data format
LOAD DATA
INFILE '/export/home/biflpu17/spartan/data_files/GF_Orders1.csv'
APPEND
INTO TABLE temporary_orders
FIELDS TERMINATED BY "," optionally enclosed by '"'
trailing nullcols
(
OrderId integer,
OrderDate Date,
RequiredDate date,
ShippedDate date,
Shipvia integer,
Freight integer,
ShipName char,
ShipAddress char,
Shipcity char,
ShipRegion char,
ShipPostalCode char,
ShipCountry char,
LastName char,
FirstName char,
Title char,
TitleOfCourtesy char,
BirthDate date,
HireDate date,
EmpAddress char,
EmpCity char,
EmpRegion char,
EmpPostalcode char,
EmpCountry char,
Homephone char,
Extension char,
Photo char,
Notes char,
ReportsTo integer,
CustomerID char,
CompanyName char,
ContactName char,
ContactTitle char,
CusAddress char,
CusCity char,
CusRegion char,
CusPostalCode char,
CusCountry char,
CusPhone char,
CusFax char,
ShipperCompanyName char,
ShipperPhone char
)
Record 6: Rejected - Error on table TEMPORARY_ORDERS, column EMPPOSTALCODE.
second enclosure string not present
[Updated on: Sat, 03 November 2007 04:00] by Moderator Report message to a moderator
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Sep 06 23:00:36 CDT 2024
|