Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nice order to create
Message
From
18/03/2016 07:23:05
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
18/03/2016 06:26:34
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:
01633337
Views:
42
If I use
TEXT TO lcx NOSHOW  
1
10
2
03
1.1
12.R
1.1.R
1201.1.RBX.250.R.1
1201.1.R.250.R.1
1201.1.RBX.1.R.1
1.R
1.R.1
A
B
AA
5.R
CDXB
ENDTEXT &&lcx 
<pre>

It will fail on the RBX;R;RRBX. The problem ist that a generic number of <i>dot+something groups</i> is hard without some loop.

I think I will mix your code with the function approach.

Thank you (_ _)


><PRE>
>INDEX ON PADL(IIF(ISDIGIT(LEFT(ALLTRIM(item),1)),TRANSFORM(VAL(STREXTRACT(ALLTRIM(item),"",".",1,2)),"@L " + REPLICATE("9",LEN(item))),ALLTRIM(item)),LEN(item),"@") TAG anIndex
>
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