How did you end up with such a strange data set? Are you trying to reverse engineer something?
It came as an Excel file, which is weird indeed as such (Sample Data):
[TABLE="width: 1152"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]RULE_ID[/TD]
[TD]START_DATE[/TD]
[TD]END_DATE[/TD]
[TD]NAME[/TD]
[TD]COMPONENT[/TD]
[TD]COMPONENTVAL[/TD]
[TD]CURRENCY[/TD]
[TD]UOM[/TD]
[TD]COND[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]8/27/2008[/TD]
[TD][/TD]
[TD]CW Carry Rail Direct Discount W,N[/TD]
[TD]DISCOUNT[/TD]
[TD].5[/TD]
[TD]CAD[/TD]
[TD]CWT[/TD]
[TD] Sold to party = 100092131 And Price Group = 27 And Shipping condition = RR And Price Group Includes 19,22,25,27,29[/TD]
[/TR]
</tbody>[/TABLE]
The desired result is:
[TABLE="width: 1431"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]RULE_ID[/TD]
[TD]START_DATE[/TD]
[TD]END_DATE[/TD]
[TD]NAME[/TD]
[TD]COMPONENT[/TD]
[TD]COMPONENTVAL[/TD]
[TD]CURRENCY[/TD]
[TD]UOM[/TD]
[TD]
SOLD TO PARTY [/TD]
[TD]
PRICE GROUP [/TD]
[TD]
SHIPPING CONDITION [/TD]
[TD]
PRICE GROUP INCLUDES [/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]8/27/2008[/TD]
[TD][/TD]
[TD]CW Carry Rail Direct Discount W,N[/TD]
[TD]DISCOUNT[/TD]
[TD].5[/TD]
[TD]CAD[/TD]
[TD]CWT[/TD]
[TD="align: right"]100092131[/TD]
[TD="align: right"]27[/TD]
[TD] RR [/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]8/27/2008[/TD]
[TD][/TD]
[TD]CW Carry Rail Direct Discount W,N[/TD]
[TD]DISCOUNT[/TD]
[TD].5[/TD]
[TD]CAD[/TD]
[TD]CWT[/TD]
[TD="align: right"]100092131[/TD]
[TD="align: right"]27[/TD]
[TD] RR [/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]8/27/2008[/TD]
[TD][/TD]
[TD]CW Carry Rail Direct Discount W,N[/TD]
[TD]DISCOUNT[/TD]
[TD].5[/TD]
[TD]CAD[/TD]
[TD]CWT[/TD]
[TD="align: right"]100092131[/TD]
[TD="align: right"]27[/TD]
[TD] RR [/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]8/27/2008[/TD]
[TD][/TD]
[TD]CW Carry Rail Direct Discount W,N[/TD]
[TD]DISCOUNT[/TD]
[TD].5[/TD]
[TD]CAD[/TD]
[TD]CWT[/TD]
[TD="align: right"]100092131[/TD]
[TD="align: right"]27[/TD]
[TD] RR [/TD]
[TD="align: right"]27[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]8/27/2008[/TD]
[TD][/TD]
[TD]CW Carry Rail Direct Discount W,N[/TD]
[TD]DISCOUNT[/TD]
[TD].5[/TD]
[TD]CAD[/TD]
[TD]CWT[/TD]
[TD="align: right"]100092131[/TD]
[TD="align: right"]27[/TD]
[TD] RR [/TD]
[TD="align: right"]29
[/TD]
[/TR]
</tbody>[/TABLE]
Is there anyway to convert that last column so it would pull out the fields and what it equals?