#13 Date time sorting

[Yearling]

Sorting by date/time doesn't work correctly for middle european formats of date (day.month.year) i.e. 30.1.2022 (i have checked "Detect date/time values in various formats." in Settings on "Detect types" tab) - date time is sorting now like a text string.
Look 1 and 2 collumn in test.csv

[Yearling]

Similar behave (sorting like a string not a number) numeric columns when decimal separator is comma instead of point (look at 11th collumn "RAM" in test.csv)

[Raphael Noeldner]

Hello Yearling,
Thank you for point this out, I will look into this.
When a date or number format is recognized the columns are right bound and displayed in blue, for these columns there should be special filter menu...
I could reproduce behaviour you described in the latest version, this is defiantly not correct.

Once I have a fix I will update the release.

[Raphael Noeldner]

The issue should be fixed in the new release, the filter does show the values in local user settings but filtering must be done in english locale.

[Raphael Noeldner]

Hello Yearling,

I think i now know what is happening... Please open the file again and see the log (glasses icon)
The logs for the file shows:
...
21:59:52 "Time" – 4 values found in 4 rows. Not enough sample values – Format : "Text"
21:59:52 "BootTime" – 4 values found in 4 rows. Not enough sample values – Format : "Text"
21:59:52 "UserDomain" – 4 values found in 4 rows. Not enough sample values – Format : "Text"
...
21:59:52 "RAM" – 4 values found in 4 rows. Not enough sample values – Format : "Text"
21:59:52 "OS" – 1 values found in 4 rows. Not enough sample values – Format : "Text"
...

If there are not enough rows of data determining the right format is problematic and risky.
If you change the minimum number of samples required to be sure in the detection tab of settings (by default its 5).
All but one of the dates in the file could be "Day.Month.Year" or "Month.Day.Year"