Difference between revisions of "Label Functions"

From Commander4j Wiki
Jump to: navigation, search
Line 16: Line 16:
  
 
== PADLEFT ==
 
== PADLEFT ==
 +
<br>
 +
Syntax    < PADLEFT(string,len,char)><br>
 +
example < PADLEFT(<* PROD_QUANTITY*>,4,0)><br>
  
 
== PADRIGHT ==
 
== PADRIGHT ==
 +
<br>
 +
Syntax    < PADRIGHT(string,len),char><br>
 +
example < PADRIGHT(<*PROD_QUANTITY*>,4,)><br>
 +
 
== UPPERCASE ==
 
== UPPERCASE ==
 +
<br>
 +
Syntax    < UPPERCASE(string)><br>
 +
example < UPPERCASE(<*DESCRIPTION*>)><br>
 +
 
== LOWERCASE ==
 
== LOWERCASE ==
 +
<br>
 +
Syntax    < RIGHT(string,len)><br>
 +
example < RIGHT(<*SSCC*>,3)><br>
 +
 
== TRIM ==
 
== TRIM ==
 +
<br>
 +
Syntax    < RIGHT(string,len)><br>
 +
example < RIGHT(<*SSCC*>,3)><br>
 +
 
== LTRIM ==
 
== LTRIM ==
 +
<br>
 +
Syntax    < RIGHT(string,len)><br>
 +
example < RIGHT(<*SSCC*>,3)><br>
 +
 
== RTRIM ==
 
== RTRIM ==
 +
<br>
 +
Syntax    < RIGHT(string,len)><br>
 +
example < RIGHT(<*SSCC*>,3)><br>
 +
 
== TIMESTAMP ==
 
== TIMESTAMP ==
 +
<br>
 +
Syntax    < RIGHT(string,len)><br>
 +
example < RIGHT(<*SSCC*>,3)><br>
 +
 
== USERNAME ==
 
== USERNAME ==
 +
<br>
 +
Syntax    < RIGHT(string,len)><br>
 +
example < RIGHT(<*SSCC*>,3)><br>
 +
 
== VERSION ==
 
== VERSION ==
 +
<br>
 +
Syntax    < RIGHT(string,len)><br>
 +
example < RIGHT(<*SSCC*>,3)><br>
 +
 
== IIF ==
 
== IIF ==
 +
<br>
 +
Syntax    < RIGHT(string,len)><br>
 +
example < RIGHT(<*SSCC*>,3)><br>
 +
 
== EXPIRYDATE ==
 
== EXPIRYDATE ==
 +
<br>
 +
Syntax    < RIGHT(string,len)><br>
 +
example < RIGHT(<*SSCC*>,3)><br>

Revision as of 12:58, 7 March 2014

SUBSTRING


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


LEFT


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

RIGHT


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

PADLEFT


Syntax < PADLEFT(string,len,char)>
example < PADLEFT(<* PROD_QUANTITY*>,4,0)>

PADRIGHT


Syntax < PADRIGHT(string,len),char>
example < PADRIGHT(<*PROD_QUANTITY*>,4,)>

UPPERCASE


Syntax < UPPERCASE(string)>
example < UPPERCASE(<*DESCRIPTION*>)>

LOWERCASE


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

TRIM


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

LTRIM


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

RTRIM


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

TIMESTAMP


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

USERNAME


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

VERSION


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

IIF


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

EXPIRYDATE


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