need assistance parsing data into columns

bilal0310

Hi , I'm trying to parse data into separate columns from a .txt input that I have. Below is a screenshot with the red lines indicating a separate column that's needed. I was able to parse some data using RegEx but having issues with col 2 & Col3 since there is only one space between them. Any help appreciated.

parse_help.xlsx

mceleavey

Hi @bilal0310 ,

I simply replaced the double spaces or more than double spaces with a ^ using regex.

I then simply split out using text to columns.

Hope this helps,

M.

solution.yxmd