Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: M. Akram Bhatti
  Where is M. Akram Bhatti?
 Riyadh
 Saudi Arabia
 M. Akram Bhatti
 Tags
Subject: RE: Checking of Valid File name
Thread ID: 228465 Message ID: 228479 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 Category: Projects and Design
Date: Tuesday, May 19, 2009 10:00:41 AM         
   


> >
> > Q. How can i replace these character if found in Accna with space
> >
> > e.g.
> >
> >
lcAccna = Accna
> > 
> > lcAccna=CHRTRAN(lcAccna,'/','')

> > Now here in 1 command how can i replace all not allowed charcters in file name with space
>
> you can use STRTRAN() function for this purpose in a nested way.
>
>
lcAccna = STRTRAN(STRTRAN(STRTRAN(STRTRAN(accna, "<", ""), ">", ""), "|", ""), ":", "")
> 

> Regards,
> Akram

If you use CHRTRAN() then all is much more easie:
lcAccna = CHRTRAN(accna, "<>|:", "")


-----------------
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.

ENTIRE THREAD

Checking of Valid File name Posted by Khurram Tahir @ 5/19/2009 8:43:45 AM
RE: Checking of Valid File name Posted by M. Akram Bhatti @ 5/19/2009 8:53:57 AM
RE: Checking of Valid File name Posted by Khurram Tahir @ 5/19/2009 8:59:32 AM
RE: Checking of Valid File name Posted by M. Akram Bhatti @ 5/19/2009 9:06:26 AM
RE: Checking of Valid File name Posted by Borislav Borissov @ 5/19/2009 10:00:41 AM
RE: Checking of Valid File name Posted by M. Akram Bhatti @ 5/19/2009 9:32:41 AM
RE: Checking of Valid File name Posted by Joseph Agarpao @ 5/19/2009 9:44:11 AM
RE: Checking of Valid File name Posted by tushar @ 5/19/2009 10:57:52 AM