SQL*Loader Help

From: Neil Greene <deepthought!neil_at_ms.uky.edu>
Date: 5 May 92 20:36:25 GMT
Message-ID: <1992May5.203625.1475_at_deepthought.uucp>


I have want appears to be a combination of a fixed/variable length file from which I need to load data into an Oracle table. Here is the format of the table:

> SQL> describe rulings;
> Name Null? Type
> ------------------------------- -------- ----
> RULINGNO CHAR(7)
> NASRISNO NOT NULL CHAR(7)
> RULINGDATE NOT NULL DATE
> TRACK CHAR(3)
> STATE CHAR(3)
> LICENSETYPE CHAR(3)
> DIVISION NUMBER(1)
> COMMISSION CHAR(3)
> COMMISSIONREFID CHAR(7)
> RULINGTYPEID CHAR(15)
> RULINGTAG CHAR(7)
> ENTRYDATE DATE
> FINE NUMBER(7,2)
> STARTDATE DATE
> ENDATE DATE
> DRUGID CHAR(7)
> DRUGCLASS CHAR(2)
> RULINGTEXT LONG
Here is some of the data:

01000019111080AQUN Y006920002T91-86        057 DAYS - CARELESS RIDING.///
01000019009100FL N Y006900039T89           057 DAYS - CAUSING INTERFERENCE.///
01000019004050AQUN Y006900018T             00RE: RULING OF 3-30: THE BOARD  
HAVING CONFIRMED RULING,       SUSPENDED 8-19 THRU 8-28.///
01000019003300NYRN Y006900017T             00RE: RULING OF 8-27-89: DECISION  
CONFIRMED. ORDERED THAT 10 DAY PENALTY BE SERVED IN AUGUST OF 1990 AT THE DISCRETION OF THE STATE STEWARD AT THAT TRACK.///
01000018908270SARN Y006890045T             0010 DAYS THRU 9-9 - CAUSING  
INTERFERENCE. (STAYED PENDING     A HEARING).///

Looking at the data, there are fixed positions assigned for fields except for the last field which contains the text of the ruling and may be of variable length terminated by "///". To add to the problems, the rulings text MAY contain an embeded <CR> character which I would like to strip if found.

Anyone's help on this would be greatly appreciative. Thanks!!

-- 
Neil Greene
ARCI, Inc.
Kentucky NeXT User Group, Inc.
Phone: 606.254.4060
Received on Tue May 05 1992 - 22:36:25 CEST

Original text of this message