Date Formats DOS

Help Activities
, ,
1

Hello All,

Please help me out solve the attached problem.
Date_Format.txt (468 Bytes)

|Pattern 1|2023 Reviewed DOS: 12/22(1)-12/28/23|
|Pattern 2|2023 Reviewed DOS: 12/27(1-3)/23|
|Pattern 3|2023 Reviewed DOS: 2/14-2/21, 12/27/23|
|Pattern 4|2023 Reviewed DOS: 5/16(2), 12/4-12/26/23|
|Pattern 5|2023 Reviewed DOS: 12/7(8), 12/8(3), 12/27(1-2)/23|

Thanks in Advance

2

Are these the only variations or is this the result of manual data entry, so the input format can be practically anything?

3

These are the only patterns Identified as of now

4

ReformatDateString.xaml (10.8 KB)

It’s not a complete solution, and the code is not 100% clean, but I’m sure you can do the rest.
Thi one reformats the string part “2023 Reviewed DOS: 12/22(1)-12/28/23” into the desired output,and should work for all format variations.

2 Likes
5

Thank you @Jeroen_van_Loon :grinning:

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.