Difference between revisions of "Label Functions"

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

Revision as of 13:03, 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 < LOWERCASE(string)>
Example < LOWERCASE(<* DESCRIPTION*>)>

TRIM


Syntax < TRIM(string)>
Example < TRIM(<* DESCRIPTION*>)>

LTRIM


Syntax < LTRIM(string)>
Example < LTRIM(<* DESCRIPTION*>)>

RTRIM


Syntax < RTRIM(string)>
Example < RTRIM(<* DESCRIPTION*>)>

TIMESTAMP


Syntax < TIMESTAMP(format)>
Example < TIMESTAMP(dd MM yyyy)>

USERNAME


Syntax < USERNAME()>
Example < USERNAME()>

VERSION


Syntax < RIGHT()>
Example < RIGHT()>

IIF


Syntax < VERSION()>
Example < VERSION()>

EXPIRYDATE


Syntax < EXPIRYDATE()>
Example < EXPIRYDATE(dd MM yyyy)>