Label Functions: Difference between revisions

From Commander4j Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
== SUBSTRING ==
== SUBSTRING ==
 
<br>
syntax <SUBSTRING(string,start,len)><br>
syntax <SUBSTRING(string,start,len)><br>
example <SUBSTRING(<*SSCC*>,1,3)><br>
example <SUBSTRING(<*SSCC*>,1,3)><br>
Line 6: Line 6:


== LEFT ==
== LEFT ==
 
<br>
example <LEFT(<*SSCC*>,1,3)>
example <LEFT(string,len)><br>
example <LEFT(<*SSCC*>,3)><br>


== RIGHT ==
== RIGHT ==

Revision as of 13:54, 7 March 2014

SUBSTRING


syntax <SUBSTRING(string,start,len)>
example <SUBSTRING(<*SSCC*>,1,3)>


LEFT


example <LEFT(string,len)>
example <LEFT(<*SSCC*>,3)>

PADLEFT

PADRIGHT

UPPERCASE

LOWERCASE

TRIM

LTRIM

RTRIM

TIMESTAMP

USERNAME

VERSION

IIF

EXPIRYDATE