Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: subhankar pandey
  Where is subhankar pandey?
 Kolkata
 India
 subhankar pandey
 To: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: TextToColumns issue
Thread ID: 210649 Message ID: 211188 # Views: 25 # Ratings: 0
Version: Visual FoxPro 6 Category: Active X Controls & OLE Automation
Date: Saturday, January 10, 2009 5:48:25 AM         
   


> > Cetin,
> > First,
> >
TEXT TO myText noshow 

> > is not supported in VFP6
> > second, it is something like this
> >
> > lcFname = Sys(2023)+'\'+Sys(2015)+'.txt'
> > SET Textmerge To (m.lcFname) Noshow
> > SET Textmerge On
> > TEXT 
> > "0001","VFP7",01/01/2002,"skipme",30/01/2003,001
> > "0002","VFP8",01/31/2003,"skipme",29/02/2000,002
> > "0002","C#",01/31/2003,"skipme",29/02/2000,002
> > EndText

> > Third is, without specify column range it will be an eror i.e.
> >
> > .Application.Selection.TextToColumns(.Range('A1'), xlDelimited, ;
> > 

> > instead of
> > i.e.
> >     .Columns("A:A").Select	
> >    .Application.Selection.TextToColumns(.Range('A1'), xlDelimited, ;
> > 

> >
> > regards
> > Subhankar
>
> Subhankar,
> do yourself a favor,
> do not teach Cetin with MS Office automation, he forget about it more that we both will ever know.
> Believe me, he DID test his code before posting it, unlike me :-)
> About VFP6,
> It is time to upgrade :-)
> Believe me only the report enhancements worth every cent you spent (that is of course if you didn't decide to switch to other platform)
>
>
> -----------------
> Borislav Borissov
>
> Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> The only thing normal about database guys is their tables.

Hi Borislav,
Pls pls pls do not misunderstand.
I dont want to teach anybody here, I hv just communicating with everybody here to share my view.
Mr. Cetin is very nice to me that he had solved so many query I have faced earlier.

Please excuse.
Subhankar



COMPLETE THREAD
TextToColumns issue Posted by subhankar pandey @ 1/7/2009 7:04:15 AM
RE: TextToColumns issue Posted by Anil Sharma @ 1/7/2009 8:14:58 AM
RE: TextToColumns issue Posted by subhankar pandey @ 1/7/2009 1:01:44 PM
RE: TextToColumns issue Posted by Yousfi Benameur @ 1/7/2009 2:10:33 PM
RE: TextToColumns issue Posted by subhankar pandey @ 1/8/2009 5:32:17 AM
RE: TextToColumns issue Posted by Cetin Basoz @ 1/7/2009 2:15:19 PM
RE: TextToColumns issue Posted by subhankar pandey @ 1/8/2009 6:11:31 AM
RE: TextToColumns issue Posted by Cetin Basoz @ 1/8/2009 4:39:00 PM
RE: TextToColumns issue Posted by subhankar pandey @ 1/9/2009 6:49:09 AM
RE: TextToColumns issue Posted by Cetin Basoz @ 1/9/2009 6:21:23 PM
RE: TextToColumns issue Posted by Borislav Borissov @ 1/9/2009 7:27:13 PM
RE: TextToColumns issue Posted by subhankar pandey @ 1/10/2009 5:48:25 AM