| Re: Data file column skipping [message #70867] |
Thu, 01 August 2002 00:54 |
Mnjunath Narayana
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
Do you know how to load this kind of invoice data using sql loader. Because each segment for ex: I110 will have invoice number details and
I113 will have address details and etc.,
Your help is very much appreciated.
I1020020611112801Z 255553 YF00NSPUSD NN0
I11LABARGE, JIM 8*892-5544 MS-G78356 J2CC0 020611
I12DESOUSA, ALAN 8*882-3360
I13NUOVO PIGNONE (C/O FALCON)
I13SAVINO DEL BENE, B.B.A.
I13149-10 183RD ST.
I13(JAMAICA, NY)
I13QUEENS, NY 11413
I14QUEENS NY11413
I17GE ENGINE SERVICES DISTRIBUTIO
I171800 DONALDSON ROAD
I17ERLANGER, KY 41018
I18ERLANGER KY41018
I19020611000000000{BILL-OF-RB001 PER CUSTOMER REQUEST
I20020611 000000000000000{
I290000007094720{0000001 000000100000007094720{EUR00000007495742BEUR00000007495742B
I30L47614G11 000000000{000000000A00000709472000{
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
