The date format used to be

22 Feb 2013 | 16:05:47 UTC

As of today it's changed to

9 Jan 2013, 8:19:19 UTC

Both are text strings, but the new one is harder to convert back into a date value - instead of simply taking the leftmost 11 characters, I now need to detect the comma. I wonder if it's possible to either introduce the leading zero or shift the comma right by one space, so I can continue to use the formula I have in Excel to extract the data value, and if so who would I ask? I know it isn't of earth-shattering importance, but it would be slightly nicer if the reporting format stayed consistent.

---

The date format used to be

22 Feb 2013 | 16:05:47 UTC

As of today it's changed to

9 Jan 2013, 8:19:19 UTC

Both are text strings, but the new one is harder to convert back into a date value - instead of simply taking the leftmost 11 characters, I now need to detect the comma. I wonder if it's possible to either introduce the leading zero or shift the comma right by one space, so I can continue to use the formula I have in Excel to extract the data value, and if so who would I ask? I know it isn't of earth-shattering importance, but it would be slightly nicer if the reporting format stayed consistent.

The good thing about standards there are so many to choose.
Personally I would prefer the date time format to be YYYY-MM-DD HH:MM:SS. So they would read "2013-01-09 08:19:19".
If you are doing things in excel you could just do a replace matching "2013," to "2013 ," which would fix your formatting issues.

---

SETI@home classic workunits: 93,865 CPU time: 863,447 hours
Join the [url=http://tinyurl.com/8y46zvu]BP6/VP6 User Group[

The date format used to be

22 Feb 2013 | 16:05:47 UTC

As of today it's changed to

9 Jan 2013, 8:19:19 UTC

Both are text strings, but the new one is harder to convert back into a date value - instead of simply taking the leftmost 11 characters, I now need to detect the comma. I wonder if it's possible to either introduce the leading zero or shift the comma right by one space, so I can continue to use the formula I have in Excel to extract the data value, and if so who would I ask? I know it isn't of earth-shattering importance, but it would be slightly nicer if the reporting format stayed consistent.

The good thing about standards there are so many to choose.
Personally I would prefer the date time format to be YYYY-MM-DD HH:MM:SS. So they would read "2013-01-09 08:19:19".
If you are doing things in excel you could just do a replace matching "2013," to "2013 ," which would fix your formatting issues.

In Excel, I've been using (via a macro) 'replace with nothing' for both | and UTC: that leaves a value which Excel itself recognises as a DateTime value which can be formatted and used in calculations.