Parsing data using the RegEx tool
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
Kyleellis21
5 - Atom
‎04-08-2024
01:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a month column that has each month fully spelled out. How would I either replace or parse that column by just keeping the first three letters of each month using the RegEx tool (ex. Jan, Feb, etc.)?
Labels:
- Labels:
- Developer
- Developer Tools
- Regex
5 REPLIES 5
Manoj_k
9 - Comet
‎04-08-2024
01:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Kyleellis21 you can use \b([A-Z][a-z]{2})\b for the desired output
binuacs
21 - Polaris
‎04-08-2024
01:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Kyleellis21 another options
‎04-08-2024
02:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is there a way to do that with the RegEx tool?
‎04-08-2024
02:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm having trouble getting it to work. I have done this before, I just forgot how to do it. I believe I started with \s when I correctly did it.
binuacs
21 - Polaris
‎04-08-2024
02:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
