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>
<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>




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


== RIGHT ==
== RIGHT ==
<br>
Syntax    < RIGHT(string,len)><br>
example < RIGHT(<*SSCC*>,3)><br>


== PADLEFT ==
== PADLEFT ==

Revision as of 13:55, 7 March 2014

SUBSTRING


Syntax <SUBSTRING(string,start,len)>
Example <SUBSTRING(<*SSCC*>,1,3)>


LEFT


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


Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>

PADLEFT

PADRIGHT

UPPERCASE

LOWERCASE

TRIM

LTRIM

RTRIM

TIMESTAMP

USERNAME

VERSION

IIF

EXPIRYDATE