Convert Txt to Excel with unstandardized spaces and symbols

[fatini.n (Fatini N Abdul Wahab)]

Hi . I need help convert txt file to excel with multiple spaces and colon separator.
I used regex System.Text.RegularExpressions.Regex.Replace((CurrentRow(0).ToString),“(\s{2,})”,“:”) to change the spaces to colon for each row and use generate data table to separate by colon but it didn’t work .

Margin Detail Report _ SD _Test.txt (33.2 KB)
Desired_Output_01.xlsx (25.4 KB)

Please help . thank you