Difference between revisions of "Label Functions"

From Commander4j Wiki
Jump to: navigation, search
 
Line 5: Line 5:
 
Example <SUBSTRING(<*SSCC*>,1,3)><br>
 
Example <SUBSTRING(<*SSCC*>,1,3)><br>
  
Input      350001611234567890
+
Input      350001611234567890<BR>
Output    350
+
Output    350<BR>
  
 
== LEFT ==
 
== LEFT ==
Line 13: Line 13:
 
Example <LEFT(<*SSCC*>,5)><br>
 
Example <LEFT(<*SSCC*>,5)><br>
  
Input      350001611234567890
+
Input      350001611234567890<BR>
Output    35000
+
Output    35000<BR>
  
 
== RIGHT ==
 
== RIGHT ==
Line 21: Line 21:
 
Example < RIGHT(<*SSCC*>,6)><br>
 
Example < RIGHT(<*SSCC*>,6)><br>
  
Input      350001611234567890
+
Input      350001611234567890<BR>
Output    567890
+
Output    567890<BR>
  
 
== PADLEFT ==
 
== PADLEFT ==
Line 29: Line 29:
 
Example < PADLEFT(<* PROD_QUANTITY*>,4,0)><br>
 
Example < PADLEFT(<* PROD_QUANTITY*>,4,0)><br>
  
Input      25
+
Input      25<BR>
Output    0025
+
Output    0025<BR>
  
 
== PADRIGHT ==
 
== PADRIGHT ==
Line 37: Line 37:
 
Example < PADRIGHT(<*PROD_QUANTITY*>,4,)><br>
 
Example < PADRIGHT(<*PROD_QUANTITY*>,4,)><br>
  
Input      25
+
Input      25<BR>
Output    2500
+
Output    2500<BR>
  
 
== UPPERCASE ==
 
== UPPERCASE ==
<br>
+
This function allows you to return a string with the input string characters all converted to uppercase<BR><BR>
 
Syntax    < UPPERCASE(string)><br>
 
Syntax    < UPPERCASE(string)><br>
 
Example < UPPERCASE(<*DESCRIPTION*>)><br>
 
Example < UPPERCASE(<*DESCRIPTION*>)><br>
 +
 +
Input      Hello World<br>
 +
Output    HELLO WORLD<br>
 +
  
 
== LOWERCASE ==
 
== LOWERCASE ==
<br>
+
This function allows you to return a string with the input string characters all converted to uppercase<BR><BR>
 
Syntax    < LOWERCASE(string)><br>
 
Syntax    < LOWERCASE(string)><br>
 
Example < LOWERCASE(<* DESCRIPTION*>)><br>
 
Example < LOWERCASE(<* DESCRIPTION*>)><br>
 +
 +
Input      Hello World<br>
 +
Output    hello world<br>
  
 
== TRIM ==
 
== TRIM ==

Latest revision as of 13:15, 7 March 2014

SUBSTRING

This function allows you to extract a smaller string from within a larger one by specifying the start position and length of the string required.

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

Input 350001611234567890
Output 350

LEFT

This function allows you to extract a specified number of characters from the left side of a string

Syntax <LEFT(string,len)>
Example <LEFT(<*SSCC*>,5)>

Input 350001611234567890
Output 35000

RIGHT

This function allows you to extract a specified number of characters from the right side of a string

Syntax < RIGHT(string,len)>
Example < RIGHT(<*SSCC*>,6)>

Input 350001611234567890
Output 567890

PADLEFT

This function allows you to pad out the size of string using a nominated character to the left of the original string

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

Input 25
Output 0025

PADRIGHT

This function allows you to pad out the size of string using a nominated character to the left of the original string

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

Input 25
Output 2500

UPPERCASE

This function allows you to return a string with the input string characters all converted to uppercase

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

Input Hello World
Output HELLO WORLD


LOWERCASE

This function allows you to return a string with the input string characters all converted to uppercase

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

Input Hello World
Output hello world

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 < VERSION()>
Example < VERSION()>

IIF


Syntax < IIF(string,string,string,string)>
Example < IIF(*CUSTOMER_ID*,SELF,Internal,External)>

EXPIRYDATE


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