Test isNaN for int, float, date; Test blank and lower & upper case for strings
NB: isNaN for int, float gets converted to 0, 0.0
number (int) | number (float) | string | date | do not sort |
---|---|---|---|---|
11 | -.18 | apple | 15.03.1986 | |
13 | 88.5 | banana | 07.08.2004 | |
-53 | -858 | orange | 27.02.2086 | |
+2 | +.18 | apple | 15.03.1913 | |
+15 | +88.5 | banana | 07.08.2004 | |
2 | 12.01 | APPLE | 15.03.1763 | |
15 | 11.99 | BANANA | 07.08.2004 | |
-53 | -858 | ORANGE | 27.02.1968 | |
xxx | xxx | |||
xxx | xxx | xxx | xxx | |
xxx12 | xxx12 | |||
012 | 012 | 99.99.9999 | ||
12xxx | 12xxx | |||
x12xxx | x12xxx |