Condition breakdown

[Mac1206]

I have this COND column in Excel which I need to import into Access but as you see, each row has this long string that needs to be converted into rows: Sold to party, Price Group and Shipping Condition would need to be represented 5 times for this particular Price Group....I'm at a lost trying to convert this....Thanks in Advance

Sold to party = 100092131 And Price Group = 27 And Shipping condition = RR And Price Group Includes 19,22,25,27,29

<tbody>
</tbody>

 

[Mac1206]

Ahhh, ok - it looks pretty complicated then. It would take lot of IF statements along with loops in vba to code that up - and given that we have only seen a few examples from a dataset of 125k this is likely to continue to expand a fair bit.

You may be able to use the code I provided above and step through the process several times splitting out a condition at a time and then amending the code for the next field, however, you would need a definite list of possible fields that would come up to ensure you don't lose any data.

I pretty much been cleaning the data up and it's 25k rows to a comma delimited file... How can I pull each field then it's value i.e., City is Frederiction, Price Group1 is 20, Price Group2 is 23 extra...I can then UNION into a PRICE_GROUP...See where I going with this and then it's doable prayerfully...lol

Sold to party , 100091461 , Price Group , 20,23 , City , BOAZ , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR

Price Group , 25 , City , FREDERICTON , Shipping condition , PU , Shipping Plant , 1323 , Price Group , 19,22,25,27,29

Sold to party , 100092818 , Price Group , 20,23 , City , LEOLA , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR

Sold to party , 100092818 , Price Group , 20,23 , City , LEOLA , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR

Sold to party , 100091460 , Price Group , 20,23 , City , CALDWELL , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR

Sold to party , 100091460 , Price Group , 20,23 , City , CALDWELL , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR

Sold to party , 100091453 , Price Group , 20,23 , City , HACKLEBURG , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR

Sold to party , 100091422 , Price Group , 20,23 , City , DOUBLE SPRINGS , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Shipping condition , PU , Plant , RECOMMEND

Sold to party , 100091422 , Price Group , 20,23 , City , DOUBLE SPRINGS , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Shipping condition , PU , Plant , RECOMMEND

Sold to party , 100092155 , Plant , RECOMMEND , Pricing Shape , 106.HPILE.SHAPE_H.HOTROLL.STRAIGHT , Deal Code , D3450 , Shipping condition , PU,RR,MM

Sold to party , 100051227 , (Pricing Shape Begins With 106 , Product , ANGLE,CHANNEL,CHANNEL_MISC) , Deal Code , TWO , Price Group , 19,22,25,27,29

Shape Size Load Quantity , 1 , Region , QCCA , Shipping Plant , 1301,1302 , Sold to party , 100060551 , Price Group , 19,22,25,27,29

Shape Size Load Quantity , 1 , Region , ONCA , Shipping Plant , 1301,1302 , Sold to party , 100061219,100061285,100060599 , Price Group , 19,22,25,27,29

Shape Size Load Quantity , 1 , Region , ONCA , Shipping Plant , 1301,1302 , Sold to party , 100061219,100060599,100061285 , Price Group , 19,22,25,27,29

Shape Size Load Quantity , 1 , Shipping Plant , 1301,1302 , Sold to party , 100092168 , Price Group , 19,22,25,27,29

Shape Size Load Quantity , 1 , Shipping Plant , 1301,1302 , Sold to party , 100092174,100092473,100092474,100092475 , Price Group , 19,22,25,27,29

Shape Size Load Quantity , 1 , Shipping Plant , 1301,1302 , Sold to party , 100092135 , Price Group , 19,22,25,27,29

Sold to party , 100092236 , Pricing Shape , 205.BAR.ROUND.HOTROLL.STRAIGHT , Steel Grade , 8630RA2,8630F , Price Group , 20 , Plant , RECOMMEND

Sold to party , 100093099 , Pricing Shape , 205.BAR.ROUND.HOTROLL.STRAIGHT , Steel Grade , 1045RAF , Price Group , 20 , Plant , RECOMMEND

Sold to party , 100093099 , Pricing Shape , 205.BAR.ROUND.HOTROLL.STRAIGHT , Steel Grade , 1080F , Price Group , 20 , Plant , RECOMMEND

Sold to party , 100093099 , Pricing Shape , 205.BAR.ROUND.HOTROLL.STRAIGHT , Steel Grade , 8620HA , Price Group , 20 , Plant , RECOMMEND

<tbody>
</tbody>