SQL*Loader Help
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: DECISIONCONFIRMED. 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.4060Received on Tue May 05 1992 - 22:36:25 CEST