Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing a multiline .txt file
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing MM:SS From Tab Delimited File and Charting | Charts and Charting in Excel | |||
importing csv file | Excel Discussion (Misc queries) | |||
Formatting a .txt file / fixed width | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) |