Challenge #4: Date Parsing
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
Myles_Stevenson
8 - Asteroid
11-01-2023
10:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Definetly not the optimal way but here is my solution
ds_tomalexsmith
8 - Asteroid
11-07-2023
03:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CoG
14 - Magnetar
11-07-2023
04:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Got to practice some Regex, which is always appreciated.
danielprince
7 - Meteor
11-08-2023
06:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A great case scenario using RegEx, for this exercise I was able to resolve only using RegEx and forms
Spoiler
First RegEx use Parse the second use Replace
JosFKirby
6 - Meteoroid
11-12-2023
02:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ecvaldez10
5 - Atom
11-13-2023
09:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
shrestha_nitesh
8 - Asteroid
11-14-2023
08:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ToniZheng
6 - Meteoroid
11-17-2023
05:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
StevenP
8 - Asteroid
11-29-2023
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My Solution:
Spoiler
Regex Date Parse formula: (\d{1,2}-\D+-\d{2,4}|\D{3} \d{1,2}, \d{2,4}|\D{3} \d{1,2} \d{2,4})
Regex Date Parse formula: (\d{1,2}-\D+-\d{2,4}|\D{3} \d{1,2}, \d{2,4}|\D{3} \d{1,2} \d{2,4})
BrianJohnson
8 - Asteroid
11-30-2023
09:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the great challenge. REGEX has not been a strongpoint of mine so it was a great learning experience. I had first tried to use REGEX within the formula tool to avoid creating extra columns, but had trouble making that work so I went forward with the REGEX tool.