We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How would I create a Regex expression to parse a column into separate columns based on ;#

Hoss2434
7 - Meteor

Hello,

 

I am trying to use Regex to parse text into columns into separate columns based on special characters. Here is an example of the desired output:

 

Before:

;#Value one;#Value two;#Value three;#

 

After:

Value oneValue twoValue three

 

Any help would be appreciated.

 

Thanks!

2 REPLIES 2
flying008
15 - Aurora

Hi, @Hoss2434 

 

There are 2 ways to get your want:

 

录制_2023_02_08_12_28_25_501.gif

 

******

If it can help you , please mark it as a solution and give a like for more share.

binuacs
21 - Polaris

@Hoss2434 One way of doing this with the Regex Tokenize method

 

 

binuacs_0-1675841043866.png

 

Labels
Top Solution Authors