Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove /
Message
From
17/09/2008 02:08:47
Mohammed Qasem
Jordan Telecom
Amman, Jordan
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Remove /
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01347847
Message ID:
01348119
Views:
14
thank you, it works for fields only have /,
and remove others ,
i try it as below, it works
SCAN for atc(trim('/') ,id_no)>0 
m.tt=left(id_no,+AT('/',id_no)-1)
replace id_no WITH m.tt
ENDSCAN
>lcValue='1234567/6543'
>? left(lcValue,at('/'lcValue)-1)
Previous
Reply
Map
View

Click here to load this message in the networking platform