View files by name does not sort correctly

[Tom Miller]

I have a folder with a large number of files that I need
to walk through and verify that there are no gaps in the
file names. These are image files (single page TIFF) and
are named with a common root for each multipage document
and if more than one page long a suffix in the file name.
For example,

EX0001.TIF
EX0002001.TIF
EX0002002.TIF
EX0003.TIF

When displayed in Windows Explorer they are sorted

EX0001.TIF
EX0003.TIF
EX0002001.TIF
EX0002002.TIF

Clearly this is incorrect if alpha sorting is used. How
can I make it work correctly?

[gls858]

I think what you're seeing here is an ASCII sort.
The computer sees them as numbers and EX0002001
is greater than EX0003 and less than EX0002002.
It's not the machine it's the way you're
numbering the files.

gls858
"Tom Miller" > wrote in message ...
> I have a folder with a large number of files that I need
> to walk through and verify that there are no gaps in the
> file names. These are image files (single page TIFF) and
> are named with a common root for each multipage document
> and if more than one page long a suffix in the file name.
> For example,
>
> EX0001.TIF
> EX0002001.TIF
> EX0002002.TIF
> EX0003.TIF
>
> When displayed in Windows Explorer they are sorted
>
> EX0001.TIF
> EX0003.TIF
> EX0002001.TIF
> EX0002002.TIF
>
> Clearly this is incorrect if alpha sorting is used. How
> can I make it work correctly?
>
>

[Tom Miller]

Do you even know what ASCCII is? This worked correctly in
Win2000 and below. And since when can a number start with
EX? What if the file name was ABC1EFG.XXX. Just because
it has a number in it doesn't make it a number.


>-----Original Message-----
>I think what you're seeing here is an ASCII sort.
>The computer sees them as numbers and EX0002001
>is greater than EX0003 and less than EX0002002.
>It's not the machine it's the way you're
>numbering the files.
>
>gls858
>"Tom Miller" > wrote in message
...
>> I have a folder with a large number of files that I need
>> to walk through and verify that there are no gaps in the
>> file names. These are image files (single page TIFF)
and
>> are named with a common root for each multipage document
>> and if more than one page long a suffix in the file
name.
>> For example,
>>
>> EX0001.TIF
>> EX0002001.TIF
>> EX0002002.TIF
>> EX0003.TIF
>>
>> When displayed in Windows Explorer they are sorted
>>
>> EX0001.TIF
>> EX0003.TIF
>> EX0002001.TIF
>> EX0002002.TIF
>>
>> Clearly this is incorrect if alpha sorting is used. How
>> can I make it work correctly?
>>
>>
>
>
>.
>

[Tom Miller]

Please ignore previous post. It was rude and out of
order. I am sorry.


>-----Original Message-----
>I think what you're seeing here is an ASCII sort.
>The computer sees them as numbers and EX0002001
>is greater than EX0003 and less than EX0002002.
>It's not the machine it's the way you're
>numbering the files.
>
>gls858
>"Tom Miller" > wrote in message
...
>> I have a folder with a large number of files that I need
>> to walk through and verify that there are no gaps in the
>> file names. These are image files (single page TIFF)
and
>> are named with a common root for each multipage document
>> and if more than one page long a suffix in the file
name.
>> For example,
>>
>> EX0001.TIF
>> EX0002001.TIF
>> EX0002002.TIF
>> EX0003.TIF
>>
>> When displayed in Windows Explorer they are sorted
>>
>> EX0001.TIF
>> EX0003.TIF
>> EX0002001.TIF
>> EX0002002.TIF
>>
>> Clearly this is incorrect if alpha sorting is used. How
>> can I make it work correctly?
>>
>>
>
>
>.
>

[gls858]

np...it's entirely possible that I'm wrong. Certainly my choice of
the word numbers to describe the examples was a poor one.
I have run across this with some reports I run for our company.
type 1, 10, 101, 1001 in a column in Excel and sort it.
you would think it would sort exactly as typed but it doesn't
it sorts it 1,10,1001, 101. Even though the names start with
letters I think it sorting them just like the above example.

gls858

"Tom Miller" > wrote in message ...
> Please ignore previous post. It was rude and out of
> order. I am sorry.
>
>
> >-----Original Message-----
> >I think what you're seeing here is an ASCII sort.
> >The computer sees them as numbers and EX0002001
> >is greater than EX0003 and less than EX0002002.
> >It's not the machine it's the way you're
> >numbering the files.
> >
> >gls858
> >"Tom Miller" > wrote in message
> ...
> >> I have a folder with a large number of files that I need
> >> to walk through and verify that there are no gaps in the
> >> file names. These are image files (single page TIFF)
> and
> >> are named with a common root for each multipage document
> >> and if more than one page long a suffix in the file
> name.
> >> For example,
> >>
> >> EX0001.TIF
> >> EX0002001.TIF
> >> EX0002002.TIF
> >> EX0003.TIF
> >>
> >> When displayed in Windows Explorer they are sorted
> >>
> >> EX0001.TIF
> >> EX0003.TIF
> >> EX0002001.TIF
> >> EX0002002.TIF
> >>
> >> Clearly this is incorrect if alpha sorting is used. How
> >> can I make it work correctly?
> >>
> >>
> >
> >
> >.
> >