Difference between revisions of "Label Functions"

From Commander4j Wiki
Jump to: navigation, search
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 12:54, 7 March 2014

SUBSTRING


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


LEFT


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

RIGHT

PADLEFT

PADRIGHT

UPPERCASE

LOWERCASE

TRIM

LTRIM

RTRIM

TIMESTAMP

USERNAME

VERSION

IIF

EXPIRYDATE