RegEx Parsing problem
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
14 - Magnetar
‎01-20-2023
04:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I was just playing around with some data earlier and stumbled on a nice RegEx problem:
Two approaches so far for it:
1. Parsing + some data manipulation to get it into desired format
2. Identifying the groups singularly via replace, & then some text manipulation. One tool, looks cleaner:
Just thought I'd share. Maybe the insights prove useful for somebody.
Labels:
- Labels:
- Data Investigation
- Parse
- Preparation
- Regex
3 REPLIES 3
n8rushton
Alteryx Alumni (Retired)
‎01-20-2023
07:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I used 3 reg parse tools.
The first being ([\w\s]*)
The second being .*?(\(\d*\))
The third being .*?(#\d*)\s?
I'm sure there is a way to get them all jammed into one tool, but I'm lazy and it complicates
Raj
16 - Nebula
‎01-22-2023
10:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for sharing.
grazitti_sapna
17 - Castor
‎01-22-2023
10:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
