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: Arslan Noman
  Where is Arslan Noman?
 Hyderabad
 Pakistan
 Arslan Noman
 Tags
Subject: RE: Index
Thread ID: 373720 Message ID: 373728 # Views: 40 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, March 26, 2013 3:46:07 AM         
   


> >
> > 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",""));
> +PADL(ALLTRIM(CHRTRAN(places,"abcdefghijklmnopqrstuvwxyz","")),nwnum,'0');
>  TAG places


Thanks my countryman, problem solved

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