Dividing columns

[sumanthskumar]

The Value column has two chess moves. The first one from the white player and the second one from the black player. E.g:- In "1. e4 e5"  "1." is the move number "e4" the white's move and "e5" is the black's move. I want the Value column to be divided into two, "black" and "white" for each Game ID. Some of the moves end with "+" and "#". Some games also have multiple spaces between each move. Can someone please help me out?

 

[LordNeilLord · Accepted solution]

Hey @sumanthskumar 

This is close, you can play around with the regex to get it closer

[sumanthskumar]

Hey,

I was stuck at this for hours. Thanks for the help, means a lot!