Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tahir Iqbal
  Where is Tahir Iqbal?
 Lahore
 Pakistan
 Tahir Iqbal
 To: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 Tags
Subject: RE: Index
Thread ID: 373720 Message ID: 373722 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, March 26, 2013 2:58:32 AM         
   


> > I have following data
> >
> >
> > Create Cursor CITY (places c(20))
> > 
> > Insert Into city Values("1 DB")
> > Insert Into city Values("95 DB")
> > Insert Into city Values("25 DNB")
> > Insert Into city Values("78 BC")
> > Insert Into city Values("9 DRB")
> > Insert Into city Values("67 DB")
> > Insert Into city Values("LAHORE")
> > Insert Into city Values("33 BC")
> > Insert Into city Values("47 DNB")
> > Insert Into city Values("59 DRB")
> > Insert Into city Values("KARACHI")
> > 

> >
> > I want to display abvoe data in following index order
> >
> > KARACHI
> > LAHORE
> > 33 BC
> > 78 BC
> > 1 DB
> > 67 DB
> > 95 DB
> > 25 DNB
> > 47 DNB
> > 9 DRB
> > 59 DRB
> >
> > or as
> >
> > 33 BC
> > 78 BC
> > 1 DB
> > 67 DB
> > 95 DB
> > 25 DNB
> > 47 DNB
> > 9 DRB
> > 59 DRB
> > KARACHI
> > LAHORE
> >
> > what will be the index command?
>
> 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.

ENTIRE THREAD

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