PlotJuggler icon indicating copy to clipboard operation
PlotJuggler copied to clipboard

CSV: Added option to parse date/time as extended ISO 8601

Open Jofkos opened this issue 11 months ago • 0 comments

When working with data from different sources, one may encounter a various number of different date formats.

Examples include:

  • yyyy-MM-dd hh:mm:ss
  • yyyy-MM-dd hh:mm:ss.zzz
  • yyyy-MM-dd hh:mm:ss.zzzzzz (not even supported with format strings)
  • yyyy/MM/dd hh:mm:ss
  • yyyy/MM/dd hh:mm:ss.zzz
  • yyyy/MM/dd hh:mm:ss.zzzzzz (not even supported with format strings)

These are all supported by Qt's Qt::ISODateWithMs, which thus allows for instantly loading different csv's without having to adjust the date format every time. This pull request adds a user-selectable UI option to parse dates as ISO8601.

The new UI suggested for that looks like this:

New 'parse CSV' UI, with radio button ISO 8601 unchecked New 'parse CSV' UI, with radio button ISO 8601 checked

Jofkos avatar Mar 16 '24 17:03 Jofkos