Hi,
Newbie need some help,
<tbody>
</tbody>
I am trying to total up different sized items in a text string an sum the totals by the size and colour from the table above.
The items to total are "25002770" or "36003150" or "46004100" etc .. these are preceded by the number of each of these items.
the preceding characters specify how many of each.. "2x" = 2 of , "3x" = 3 of
Then in the column "Colour" is the colour of the items detailed this line.
For exmaple: 2x25002770 - "Has 2 roller doors" indicate by 2x as mentioned above.
I am trying to generate the totalled list for these items as shown in the results table below.
Any help gladly appreciated
<tbody>
</tbody>
Newbie need some help,
EXTRAS | Colour | ||||||
<colgroup><col></colgroup><tbody> </tbody> |
<tbody> </tbody> | ||||||
1x25005100, 1x25002770, 1xPAD, 1xMotor, 1xWindow |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> | ||||||
2x30003150, 1x25002770, 3xWindow |
<tbody> </tbody> | ||||||
1x25005100, 2x25002770, 1xPAD, 3xInso |
<tbody> </tbody> | ||||||
3x25002770, 1x36003150, 2xPAD, 10xWindow, 2xBarnWindow |
<tbody> </tbody> | ||||||
2x25002770 |
<tbody> </tbody> | ||||||
1x25002770, 1xPAD, 1xWindow, 1xInso, 1xLT1.2x3.5x2.595 |
<tbody> </tbody> |
<tbody>
</tbody>
I am trying to total up different sized items in a text string an sum the totals by the size and colour from the table above.
The items to total are "25002770" or "36003150" or "46004100" etc .. these are preceded by the number of each of these items.
the preceding characters specify how many of each.. "2x" = 2 of , "3x" = 3 of
Then in the column "Colour" is the colour of the items detailed this line.
For exmaple: 2x25002770 - "Has 2 roller doors" indicate by 2x as mentioned above.
I am trying to generate the totalled list for these items as shown in the results table below.
Any help gladly appreciated
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody>
</tbody>