REGEX Support Oracle text report

[imadorkous]

I am looking to get support from the Alteryx Community. I have text report from our oracle database that I want parse into columns that should look like this:

However, when I use text to columns to tool, it is just messy.

It seems like the regex tool would be the way to go, but I wasn't too sure. 

Can anyone help me on how I should tackle this?

I have added the sample txt file as well. Please let me know if you have any questions, thank you. 

[gabrielvilella · Accepted solution]

Hi @imadorkous, when inserting the file in Alteryx, select the option to read it as fixed width text file. Then you just need to click where each field begins as below:

[imadorkous]

You are the best @gabrielvilella! This solved what I was trying to do! Thank you!!

[atcodedog05]

Thank you for the knowledge share @gabrielvilella 🙂 This is something new to me 😀