Split Column

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?

Help

Accepted answers

One way of doing this.

(.+)(\(As.+)

Many thanks

Shanker V

All comments

One way of doing this.

(.+)(\(As.+)

Many thanks

Shanker V

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

Thank you

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703