Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

RegEx for Splitting Data

dholder15
7 - Meteor

How would I split a column with an example like this: B000984 muse love rhyno yogo

I ask because I can't do text to columns since there isn't a delimeter to utilize. I've done regex to get the A000984 in a separate column, but I can't get the "muse love rhyno llc computation" part. Let me know thoughts/feedback. Thanks!

 

 

 

B000984 Muse Love Rhyno Yogo

B102562 CCG Metro Tough

3 REPLIES 3
ShankerV
17 - Castor

Hi @dholder15 

 

Please find the expected output

 

ShankerV_0-1675807635253.png

 

dholder15
7 - Meteor

Hi @ShankerV ,

Thank you so much! It worked out perfectly!

binuacs
20 - Arcturus

@dholder15 One way of doing this

binuacs_0-1675807854084.png

 

Labels