Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Len function
Message
From
03/04/2001 16:48:14
David Brunelle
Université de Sherbrooke
Sherbrooke, Quebec, Canada
 
 
To
03/04/2001 16:37:40
Randy Hooper
Ranco Business Software
Tampa, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00491547
Message ID:
00491554
Views:
10
>Does vfp have function that will return how many characters are in a field.
>?len(slast) is returning the field length.
>
>Thanks Randy

I'm not 100% sure it work with field of a table, but what you said is the one that you are looking for... The function LEN(cExpression) will return the number of character in the string. If you want with or withouth traling space, until you get a space.. etc, you can put function In the LEN to get what you want : LEN(ALLTRIM("123 ") + ALLTRIM(" 456 ") + STR(789)) will return 9, and so on...
Previous
Reply
Map
View

Click here to load this message in the networking platform