Still new to Alteryx and trying to hone my Regex skills. I had data in one field in a text file and I am trying to parse, text to columns is not working, and trying fixed width using the parse tool with no luck. Getting the account number is the easy part, but my Debits & Credits are in one column separated by leading spaces. See attached Sample_data.txt.
I need it to be parsed into columns Account, Debit, Credit
