Len() returns the length of the input string.
Syntax:
Len(text)
Return data type: integer
| Example | Result |
|---|---|
| Len('Peter') | Returns '5' |
T1:
Load String, First&Second as NewString;
Load *, mid(String,len(First)+1) as Second;
Load *, upper(left(String,1)) as First;
Load * inline [
String
this is a sample text string
capitalize first letter only ];
Result
| String | NewString |
|---|---|
| this is a sample text string | This is a sample text string |
| capitalize first letter only | Capitalize first letter only |