>Hi all,
>
>I have the following problem.
>
>Customer creates a lot of paper printing files from Explorer
>
>Explorer sorts files in following order:
>
>011.txt
>012.txt
>02A.txt
>02B.txt
>020.txt
>021.txt
>
>So the paper is created this way.
>
>We talk about several hundred files.
>
>An other job creates vfp tables with the filename as field.
>
>Now the customer wants to work through all paper and alter data to the vfp table.
>
>The paper is sorted by the order its printed (no way to resort)
>
>The problen is now that vfp sorts the names with number2 first,
>
>011
>012
>020
>021
>02A
>02B
>
>so customer can not work in a next sheet / next record way.
>
>Is there som sorte collate I do miss or do see a way to sort the data like the explorer?
>
>TIA
>
>Agnes
Agnes,
The sort order of the Windows Explorer is described here
http://windowsxp.mvps.org/xpsortorder.htmThe only way out for you is to have an extra field in your cursor with the filename strtran() in such a way that the digits come after the alphabet
eg map
a, A to hex 01
b, B to hex 02
...
0 to 0x01 + 0x20 or so
Then the index has to be Machine
Then you have to watch out for the accented chars + eszet
You can try to re-educate the customer...
Gregory