SOLVED
Date Parsing help required
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
CiaranA
10 - Fireball
‎06-03-2020
06:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can anyone put their mind to parsing this set of dates easily?
Ideally I would like a date format column, but where there isn't that level of information at the minimum a month.
Nov. 10
Sep.
Mar. 17-24
July 28-Aug. 5
March
Apr. 27
Oct.
Oct. 27-31
June 2
Aug. 8-12
June 9
Feb. 2019
Solved! Go to Solution.
Labels:
- Labels:
- Parse
1 REPLY 1
13 - Pulsar
‎06-03-2020
08:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @CiaranA,
See if this is what you are looking for. I started with a RegEx and then just separated everything out. Once you have this you should be able to create your dates in different ways using filters to set up different date time conversions.
