Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
String Conversion
Message
 
 
To
03/08/2007 21:03:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01245922
Message ID:
01245932
Views:
24
lcMlist = "JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC"
lcStr = "06-2006"
? SUBSTR(lcMlist, (VAL(lcStr)-1)*4+1,3) + RIGHT(lcStr,5)
>
>Field1 has following character type data
>06-2006
>07-2007
>08-2008
>
>I want to fill Field2 with following data
>
>Jun - 2006
>Jul - 2007
>Aug - 2008
>
>May it is conversion of month to cmonth.
>
>Please help
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform