Hi
I really need help with figuring out how to extract a specific string and number from a description. The format of the text is as follows: GOLDEN TEMPLE 9KG. This is the similar structure for other string descriptions. I am looking to extract 9 and KG in 2 separate columns. How do I go about doing this? In addition, one other complexity the number can be either one digit or 2 digits and there can be a space between the 9 and KG in some cases as well