Extract numbers from start of string and remove from original string
I am looking to remove the numbers from (if there are numbers) from the start of a string - then put those number into a new column. As well as that remove those numbers from the original string.
There may be records that do not contain numbers as well , so I don't want it bombing out.
e.g. numbers could look like (of course there may be other combinations - but this is what I have seen thus far)
