I have a plain text data file of just under 100K rows. The data are all 5 to 8 digit numbers.
I sort it using
First Key From: 1
First Key Length: 10
Sort Order: Ascending
Comparison: Case insensitive or Case sensitive
The data becomes garbled.
I know that I should be using Comparison: Numeric, and when I do, all is well.
However, why are Case insensitive or Case sensitive causing the data to become garbled?
[/list]
Sort scrambling data
Moderators: AmigoJack, helios, bbadmin, Bob Hansen, MudGuard
Sort scrambling data
(2[Bb]|[^2].|.[^Bb])
That is the question.
That is the question.
case sensitive/insensitive select a sort by character order (respecting or ignoring case).
Then every word starting with an 'a' will be put before any word starting with a 'b', no matter which characters follow.
Similarly, any word starting with a '1' will be put before any word starting with '2'.
So you get something like
0
1
10
100
101
...
109
11
12
...
19
2
20
...
Then every word starting with an 'a' will be put before any word starting with a 'b', no matter which characters follow.
Similarly, any word starting with a '1' will be put before any word starting with '2'.
So you get something like
0
1
10
100
101
...
109
11
12
...
19
2
20
...