I want to import about 1000 records ( like the 2 below) into excel to
sort. What is the most efficient way to to import these to parse /
format these records to have one row as a record (vba ?? ) ? I know how
to import text files but it doesn't give the formatting options needed
for this file. I can provide details, if you need them.


Product Claim

--------------------------------------------------------------------------------

ITEM DETAILS 1 MODEL NUMBER:
E34FCGHJR465G
CODE NUMBER: 45657878345342679 NUMBER:
004753Z
MODEL: 3W45 PROD. ATTRIBUTE
3345678346
MODEL YEAR: 2002 PNC DESCRIPTION
456 4567278
PFP DESCRIPTION: MOUNT

CURRENT SERV. LIFE: 15789 MILES

REPAIR DATE: 20060123

PRODUCTION DATE: 20031002

SOLD DATE: 20050307

CLAIM DATE: 20060301

CHARGE PARTS CHARGE VENDOR RATE 0.6

TOTAL CLAIM AMOUNT: 3060 VENDOR AMOUNT:
10.36
CHARGE SPECIAL HANDLING VENDOR RATE 0.6

TOTAL CLAIM AMOUNT: VENDOR AMOUNT:

CHARGE LABOR CHARGE VENDOR RATE 0.6

TOTAL CLAIM AMOUNT: 1275 VENDOR AMOUNT:
4.356
PRR NUMBER: 1 TROUBLE CODE/DESC.
NOISE
PRR NUMBER: 2 TROUBLE CODE/DESC.
PLAY
HAYON N OUVRE PAS COMPLETEMENT

REMPLACER

REPAIR ACTION#: 1 PART NO:
904507S000
PART QUANTITY: 1 UNIT PRICE:
18.71
REPAIR ACTION#: 2 PART NO:
904517S000
PART QUANTITY: 1 UNIT PRICE:
11.89
REPAIR ACTION#: 3 OPERATION NO:
UM14A1
LABOR HOURS: 0.2

TOTAL CHARGEBACK CLAIM AMOUNT: 26.01

RECEIVER CLAIM NO: 015314060

BUSINESS TYPE PRODUCTION PART

STATE CODE NY

ADJSTMNT MEMO NO: 008677465


--------------------------------------------------------------------------------

ITEM DETAILS 2 MODEL NUMBER:
BLJALGA327EU5A----
CODE NUMBER: 1N4BA41E34C852439 NUMBER:
118340Z
MODEL: 6ZV2 PROD. ATTRIBUTE
3566892138
MODEL YEAR: 2004 PNC DESCRIPTION
84532 CASING LID TORS BAR/TAIL
PFP DESCRIPTION: LID ASSY-CASING

CURRENT SERV. LIFE: 6464 MILES

REPAIR DATE: 20060216

PRODUCTION DATE: 20030906

SOLD DATE: 20050331

CLAIM DATE: 20060301

CHARGE PARTS CHARGE VENDOR RATE 0.6

TOTAL CLAIM AMOUNT: 690 VENDOR AMOUNT:
4.14
CHARGE SPECIAL HANDLING VENDOR RATE 0.6

TOTAL CLAIM AMOUNT: VENDOR AMOUNT:

CHARGE LABOR CHARGE VENDOR RATE 0.6

TOTAL CLAIM AMOUNT: 1705 VENDOR AMOUNT:
10.23
PRR NUMBER: 3 TROUBLE CODE/DESC.
POOR GENERAL APPEARANCE
PRR NUMBER: 4 TROUBLE CODE/DESC.
INTERNAL FAILURE
CUSTOMER STATES THE RIGHT REAR CASING SUPPORT HAS COME APART SEE
SPECIAL ORDER PART
THE RIGHT REAR CASING STAY IS BROKEN OFF AT THE
BOTTOM REPLACED THE RIGHT REAR CASING STA
Y UM14AA 2

REPAIR ACTION#: 4 PART NO:
3566892138
PART QUANTITY: 1 UNIT PRICE:
6.9
REPAIR ACTION#: 5 OPERATION NO:
UM14A1
LABOR HOURS: 0.2

TOTAL CHARGEBACK CLAIM AMOUNT: 14.37

RECEIVER CLAIM NO: 015316900

BUSINESS TYPE PRODUCTION PART

STATE CODE MS

ADJSTMNT MEMO NO: 008679905

---------------------------------------


--
schnett
------------------------------------------------------------------------
schnett's Profile: http://www.excelforum.com/member.php...o&userid=12035
View this thread: http://www.excelforum.com/showthread...hreadid=534393