Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need idea for sort
Message
De
26/02/2010 09:31:27
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
26/02/2010 09:11:21
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01451160
Message ID:
01451228
Vues:
36
>Hi Craig
>
>No ::(
>
>1.1
>1.10
>1.2
>1.2.R
>10.1

I don't see any other way but to split this into fields. Each field is a string, containing a character representation of a chunk which was originally between the dots...

select getwordnum(fld, 1, "."), getwordnum(fld,2, ".") ... order by 1,2,3,4

Now if you want 1.12 to sort after 1.2, you may need to left-pad the numbers to their maximal length.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform