Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Simulating EBCDIC sort with vfp index
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Simulating EBCDIC sort with vfp index
Divers
Thread ID:
00470093
Message ID:
00470093
Vues:
70
For those who don't recall, EBCDIC is the ancient char system that orders like this in a natural ascending string sort:

1) lower alpha
2) upper alpha
3) digits

Quite the opposite of ASCII. Anyone think of a way to simulate this sort with a vfp index, on a field with mixed alphanumeric as below? These strings are varying in length, and I really want a structural index for this, not SQL or looping techniques involving code. I may be barking up the "impossible tree" here, but sometimes a fresh perspective can see some idea someone else has missed...

For example, given this sequence:

12G5A77
123C6H
12AB5
123C6h

I want to get:

12AB5
12G5A77
123C6h
123C6H
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform