Extract Date from Sentence
I have a description field for a product that has a start and end date in it. I am trying to extract the Start Date and End Date to put into separate fields in Month/Day/Year format.
Example Description: RHEL SVR STANDARD PHYSICAL OR VIRTUAL NODES Comment: 11471579 Start Date 08/30/2019 End Date 08/29/2020
Thanks,
David
Comments
-
Are you trying to extract the dates and have them put into an actual date field, or will it remain a text string? Both are possible but have different solutions.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I would like it put into a date field so that I can set reminders off that date and do calculations on the dates.
-
Ok. Will it always be "Start Date mm/dd/yyyy" or is there the potential for m/d/yy or any other variation on date, upper vs lower case, etc?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
It will always be "Start Date mm/dd/yyyy"
-
This will give you the Start Date:
=DATE(VALUE(MID([Column2]$1, FIND("Start Date", [Column Name]@row) + 17, 2)), VALUE(MID([Column Name]@row, FIND("Start Date", [Column Name]@row) + 11, 2)), VALUE(MID([Column Name]@row, FIND("Start Date", [Column Name]@row) + 14, 2)))
And this will give you the Finish Date:
=DATE(VALUE(MID([Column Name]@row, FIND("Finish Date", [Column Name]@row) + 18, 2)), VALUE(MID([Column Name]@row, FIND("Finish Date", [Column Name]@row) + 12, 2)), VALUE(MID([Column Name]@row, FIND("Finish Date", [Column Name]@row) + 15, 2)))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you this worked great!
-
Happy to help!
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives