Split a string in SQL Server using regex and use the resulted array to populate many columns in a ne...

Capturing data regex...