Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Replace

Highlighted
8 - Asteroid

Hi,

 

I'm trying to compare two columns but the problem is I have to do cleanup on one column. As seen below, I'm trying to clean up the below column where I only want to see the firm names and get rid of anything after that firm name.(\ CRD: 123242 \ IARD: 123242). The output should only have firm names. Can this be done using a replace formula or something else? Any help would be appreciated. Thank you in advance!

 

Firm
MOTIF INVESTING, INC. \ CRD: 123242 \ IARD: 123242
ARVEST INVESTMENTS, INC. \ CRD: 76839 \ IARD: 76839
BAINCO INTERNATIONAL INVESTORS LLC \ CRD: 547383 \ IARD: 547383
Highlighted
Alteryx
Alteryx

Can you use the Text to Columns tool using \ as your delimiter to split your column into two new columns on the backslash? 

Highlighted
Alteryx
Alteryx

text to columns.png

Highlighted
8 - Asteroid

Awesome:) It worked. Thank you so much for your inputs on this @BrandonB 

Labels