Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parsing with Leading spaces in one column

knamc_com
7 - Meteor

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

 

3 REPLIES 3
knamc_com
7 - Meteor

attaching my sample output

binuacs
20 - Arcturus

@knamc_com One way of doing this

image.png

knamc_com
7 - Meteor

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!!!

Labels