Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
21 - Polaris

@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
Top Solution Authors