Well spotted, I read the question but not the data.
Row 1 appears to be 2 fields, sequence and Model Number but only one
':' seperator, row 2 has two ':' sperators, row 3 and 4 only one,
whilst others, like the Vendor rates, have none.
Could be an interesting
VB parse unless the OP could re-extract
dropping the headers, I cannot see that the data will support any form
of text-to-columns separation.
--
PY & Associates Wrote:
The information provided appears to be one row of data, separated by a
blank
row;
usually four fields per row except Trouble Code/Desc and the last 5 or
6
rows;
1st row identify as Item Details
last row identify as Adjustment Memo No
You are wanting to put field names across row 1
and put data from row 2 onwards so that you can sort.
We consider you need to use VBA to achieve this.
If this is one off job, we believe it is more cost effective to pay
some
service provider to do.
"schnett" wrote
in
message ...
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
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=534393