the original data is inconsistent in the Name column as the word "Code" is followed by a ";" , blank space, "-" etc. So I was trying to use regular expression to search for the first number and then split the column there.

I have tried using regex to search for the first digit and separate() from the tidyr package :