In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Split Column

Jaspal80
7 - Meteor

I have a table which has a column with below sample data

 

Name (xx)(As-of YYYYMMDD,  Date YYYYMMDD,  Date YYYYDDDD)
Name (As-of YYYYMMDD,  Date YYYYMMDD,  Date YYYYDDDD)

 

 

I want to split the above column into two column one with > (As-of YYYYMMDD,  Date YYYYMMDD,  Date YYYYDDDD)

and other with the first part  > Name (xx)

 

How can I do this?

3 REPLIES 3
ShankerV
17 - Castor

Hi @Jaspal80 

 

One way of doing this.

 

ShankerV_0-1677589706918.png

 

ShankerV_0-1677589729448.png

 


(.+)(\(As.+)

 

Many thanks

Shanker V

 

Jaspal80
7 - Meteor

This works - can you explain what the (.+)(\(As.+) means and where can i learn this?

 

Thank you

ShankerV
17 - Castor

Hi @Jaspal80 

 (.+)(\(As.+) 

 

Each () represents new column.

(.+)

. denotes any character 

+ denotes any number of characters

 

(\(As.+) 

Then looking for next ( where we need to prefix \ before.

Then I am looking for specific word As and .+

 

Hope this help!!!

 

You can learn in many ways. Out of which few are below.

 

1. Click the +

ShankerV_1-1677590277545.png

 

ShankerV_0-1677590256338.png

 

2. Regex101.com also will help.

 

Many thanks

Shanker V

Labels
Top Solution Authors