Need urgent help: split data and put into new columns

[Sivory18]

Hi guys, need help here. As you can in table a there are 5 columns, and in column 2, data was imported into 1 word so I am wanting to separate the data and put them into their own columns. So I wo want to go from table A to table b. 

[alexnajm]

Looks like RegEx should do the trick, using the Parse method with the pattern (\d{2})(\d{2})(\d{2})(\d{2})(\d{1})