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:[TABLE="width: 56"]
<colgroup><col width="56" style="width:42pt"> </colgroup><tbody>[TR]
[TD="width: 56"]16g[/TD]
[/TR]
[TR]
[TD]24g[/TD]
[/TR]
[TR]
[TD]36g[/TD]
[/TR]
[TR]
[TD]46g[/TD]
[/TR]
[TR]
[TD]60g[/TD]
[/TR]
[TR]
[TD]80g[/TD]
[/TR]
[TR]
[TD]100g[/TD]
[/TR]
[TR]
[TD]120g[/TD]
[/TR]
[TR]
[TD]150g[/TD]
[/TR]
[TR]
[TD]180g[/TD]
[/TR]
[TR]
[TD]220g[/TD]
[/TR]
[TR]
[TD]240g[/TD]
[/TR]
[TR]
[TD]280g[/TD]
[/TR]
[TR]
[TD]320g[/TD]
[/TR]
[TR]
[TD]400g[/TD]
[/TR]
[TR]
[TD]500g[/TD]
[/TR]
[TR]
[TD]600g[/TD]
[/TR]
[TR]
[TD]800g[/TD]
[/TR]
[TR]
[TD]1000g[/TD]
[/TR]
[TR]
[TD]1200g[/TD]
[/TR]
[TR]
[TD]2000g[/TD]
[/TR]
[TR]
[TD]4000g[/TD]
[/TR]
[TR]
[TD]6000g[/TD]
[/TR]
</tbody>[/TABLE]
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.
<colgroup><col width="56" style="width:42pt"> </colgroup><tbody>[TR]
[TD="width: 56"]16g[/TD]
[/TR]
[TR]
[TD]24g[/TD]
[/TR]
[TR]
[TD]36g[/TD]
[/TR]
[TR]
[TD]46g[/TD]
[/TR]
[TR]
[TD]60g[/TD]
[/TR]
[TR]
[TD]80g[/TD]
[/TR]
[TR]
[TD]100g[/TD]
[/TR]
[TR]
[TD]120g[/TD]
[/TR]
[TR]
[TD]150g[/TD]
[/TR]
[TR]
[TD]180g[/TD]
[/TR]
[TR]
[TD]220g[/TD]
[/TR]
[TR]
[TD]240g[/TD]
[/TR]
[TR]
[TD]280g[/TD]
[/TR]
[TR]
[TD]320g[/TD]
[/TR]
[TR]
[TD]400g[/TD]
[/TR]
[TR]
[TD]500g[/TD]
[/TR]
[TR]
[TD]600g[/TD]
[/TR]
[TR]
[TD]800g[/TD]
[/TR]
[TR]
[TD]1000g[/TD]
[/TR]
[TR]
[TD]1200g[/TD]
[/TR]
[TR]
[TD]2000g[/TD]
[/TR]
[TR]
[TD]4000g[/TD]
[/TR]
[TR]
[TD]6000g[/TD]
[/TR]
</tbody>[/TABLE]
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.