I have a very long product list which lists sanding products in various forms. In the description there is a part indicating the grade of the sandpaper. This I need to move into its own column. For example currently: 120G CS561 FIBRE DISCS 100MM should become: CS561 FIBRE DISCS 100MM and 120G. The string to find and remove is one of the following:
<colgroup><col width="56" style="width:42pt"> </colgroup><tbody>
</tbody>Unfortunately, the string to move is not always at the beginning of the text but sometimes some were in the middle and sometimes at the end. But there is always a space between that string and the adjacent text.
What would be the easiest way to do this for about 2000 lines.
16g |
24g |
36g |
46g |
60g |
80g |
100g |
120g |
150g |
180g |
220g |
240g |
280g |
320g |
400g |
500g |
600g |
800g |
1000g |
1200g |
2000g |
4000g |
6000g |
<colgroup><col width="56" style="width:42pt"> </colgroup><tbody>
</tbody>
What would be the easiest way to do this for about 2000 lines.