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
Solved! Go to Solution.
@knamc_com One way of doing this
This is the solution, thank you so much. I think I hit the wrong "solved" button and I can't see where to fix it, so sorry still learning. @binuacs thank you so much!!!