Not sure if you can tell from this sample of data, but what I have are some records that are just one line, others where the second field is a description and was to long to fit on one line, they trunkated the description field, entered the part number again and continued the description followed by the date again and if the description didn't fit in two lines they did it a third time.
I only need the part number (the first field) and the date once, so the repeated entried can be discarded.
Can someone tell me if this is possible and point me in the right direction if it is?
I'm using Monarch Pro version 9.01
Any help would be appreciated!
A02T6 0000010000TIME AND EXPENSE 1991-02-01
A02T7 0000010000TIME AND EXPENSE 1991-02-01
A02T8 0000010000TIME AND EXPENSE 1991-02-01
A02T9 0000010000TIME AND EXPENSE 1991-02-01
A020100 0000010035AXLE ASSEMBLY (FRONT drive axle), Replace 1991-01-01
A020110 0000010097AXLE HOUSING (FRONT DRIVE), Replace 2000-07-31
A020120 0000010085DIFFERENTIAL carrier OR GASKET (FRONT DRIVING AXLE), R & R a 2000-07-31
A020120 0000020085nd/or Replace 2000-07-31
A020145 0000010012PINION SHAFT OIL SEAL, Replace 2000-07-31
A020150 0000010080DIFFERENTIAL Carrier Assembly (FRONT DRIVE AXLE / REMOVED), 2000-07-31
A020150 0000020080 Repair 2000-07-31
A020151 0000010060DIFFERENTIAL Carrier Assembly (FRONT DRIVE AXLE / REMOVED), 2000-07-31
A020151 0000020060 Repair 2000-07-31
A020170 0000010004LOCKING HUBS (FRONT DRIVE AXLE), Replace 1991-01-01
A020171 0000010007LOCKING HUBS (FRONT DRIVE AXLE), Replace 1991-01-01
A020190 0000010028AXLE SHAFT AND/OR SEALS (FRONT DRIVE), Replace 1991-01-01
A020190 0100010008U-joint, Replace 1991-01-01