Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Arslan Noman
  Where is Arslan Noman?
 Arslan Noman
 To: Tahir Iqbal
  Where is Tahir Iqbal?
 Tahir Iqbal
Subject: RE: Index
Thread ID: 373720 Message ID: 373725 # Views: 46 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, March 26, 2013 3:31:00 AM         

> >
> > You can't with the current structure. For that to work, you have to break the field into two, one containing the numbers, another containing characters. Then index base on character first then number.
> >
> >
> > http://sandstorm36.blogspot.com
> > http://weblogs.foxite.com/sandstorm36
> Sir I am unable to break above column into two columns
> Please help me more to do that.

Add these Lines in the bottom of your code.....

LOCAL nwnum as Integer

CALCULATE MAX(LEN(ALLTRIM(CHRTRAN(places,"abcdefghijklmnopqrstuvwxyz","")))) TO nwnum

INDEX ON ALLTRIM(CHRTRAN(places,"1234567890",""));
 TAG places


Index Posted by Tahir Iqbal @ 3/26/2013 2:50:58 AM
RE: Index Posted by Jun Tangunan @ 3/26/2013 2:55:24 AM
RE: Index Posted by Tahir Iqbal @ 3/26/2013 2:58:32 AM
RE: Index Posted by Arslan Noman @ 3/26/2013 3:31:00 AM
RE: Index Posted by Tahir Iqbal @ 3/26/2013 3:46:07 AM
RE: Index Posted by Marco Plaza @ 3/26/2013 4:29:09 AM