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.

[mceleavey]

Hi @bilal0310 ,

We'll need a sample of the data to accurately build this for you.

Can you send the data of that contained in the screenshot?

M.

[bilal0310]

hanks, just added an attachment

[mceleavey · Accepted solution]

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.

[bilal0310]

Thank you , that helped!

[mceleavey]