SOLVED
Regex to parse out text from last parentheses
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SurferJim
7 - Meteor
‎11-21-2021
11:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, Thank you in advance for your help.
In the example below, the data may have multiple parenthesis and I would like to break them out into 2 columns where the last column is always the last parenthesis.
Title | RegexOut1 | RegexOut2 |
Title 1 (A) | Title 1 | (A) |
Title 2 (B) (C) | Title 2 (B) | (C) |
Title 3 (D) (E) (F) | Title 3 (D) (E) | (F) |
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
2 REPLIES 2
AngelosPachis
16 - Nebula
‎11-21-2021
02:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-21-2021
02:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AngelosPachis ,
Thank you but your solution only works partially in my real data. I ended up looking for the pattern and insert a | delimiter. Then I use Text to Column to separate out the string.
