Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nice order to create
Message
From
18/03/2016 05:16:34
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
18/03/2016 05:11:51
Thomas Ganss (Online)
Main Trend
Frankfurt, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01633318
Message ID:
01633322
Views:
64
The number of dots is not limited, at least not reasonable. :(
Also the user might alter the field (IOW append dot letter sections or change the whole thing). Thats why I like to have it as index expression - it would sort itself.

>create 3 virtual columns with the dot as separator, order columns on padl(evl(int(val()), 999),3). Then think about the last Item, AA ;-)
>
>
>
>>Hi everybody.
>>
>>I have a list with elements like
>>
>>1
>>10
>>2
>>03
>>1.1
>>12.R
>>1.1.R
>>1.R
>>1.R.1
>>A
>>B
>>AA
>>5.R
>>
>>I need to order (by indexing) this to
>>
>>1
>>1.1
>>1.1.R
>>1.R
>>1.R.1
>>2
>>03
>>5.R
>>10
>>12.R
>>A
>>B
>>AA
>>
>>any idea to do this, as fast as possible?
>>
>>Thanks
>>
>>Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform