Split Column

[Jaspal80]

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?

[ShankerV · Accepted solution]

Hi @Jaspal80 

One way of doing this.

(.+)(\(As.+)

Many thanks

Shanker V

[Jaspal80]

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

Thank you

[ShankerV]

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 +

2. Regex101.com also will help.

Many thanks

Shanker V