Difference between revisions of "Label Functions"

From Commander4j Wiki
Jump to: navigation, search
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
== <SUBSTRING(string,start,len)> ==
+
== 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.<BR>
  
example <SUBSTRING(<*SSCC*>,1,3)>
+
Syntax    <SUBSTRING(string,start,len)><br>
 +
Example <SUBSTRING(<*SSCC*>,1,3)><br>
  
 +
Input      350001611234567890<BR>
 +
Output    350<BR>
  
== <LEFT(string,len)> ==
+
== LEFT ==
 +
This function allows you to extract a specified number of characters from the left side of a string<BR><BR>
 +
Syntax    <LEFT(string,len)><br>
 +
Example <LEFT(<*SSCC*>,5)><br>
  
example <LEFT(<*SSCC*>,1,3)>
+
Input      350001611234567890<BR>
 +
Output    35000<BR>
  
== <RIGHT(string,len)> ==
+
== RIGHT ==
 +
This function allows you to extract a specified number of characters from the right side of a string<BR><BR>
 +
Syntax    < RIGHT(string,len)><br>
 +
Example < RIGHT(<*SSCC*>,6)><br>
  
== <PADLEFT(string,size,char)> ==
+
Input      350001611234567890<BR>
 +
Output    567890<BR>
  
<PADRIGHT(
+
== PADLEFT ==
<UPPERCASE(
+
This function allows you to pad out the size of string using a nominated character to the left of the original string<BR><BR>
<LOWERCASE(
+
Syntax    < PADLEFT(string,len,char)><br>
<TRIM(
+
Example < PADLEFT(<* PROD_QUANTITY*>,4,0)><br>
<LTRIM(
+
 
<RTRIM(
+
Input      25<BR>
<TIMESTAMP(
+
Output    0025<BR>
<USERNAME(
+
 
<VERSION(
+
== PADRIGHT ==
<IIF(
+
This function allows you to pad out the size of string using a nominated character to the left of the original string<BR><BR>
<EXPIRYDATE(
+
Syntax    < PADRIGHT(string,len),char><br>
 +
Example < PADRIGHT(<*PROD_QUANTITY*>,4,)><br>
 +
 
 +
Input      25<BR>
 +
Output    2500<BR>
 +
 
 +
== UPPERCASE ==
 +
This function allows you to return a string with the input string characters all converted to uppercase<BR><BR>
 +
Syntax    < UPPERCASE(string)><br>
 +
Example < UPPERCASE(<*DESCRIPTION*>)><br>
 +
 
 +
Input      Hello World<br>
 +
Output    HELLO WORLD<br>
 +
 
 +
 
 +
== LOWERCASE ==
 +
This function allows you to return a string with the input string characters all converted to uppercase<BR><BR>
 +
Syntax    < LOWERCASE(string)><br>
 +
Example < LOWERCASE(<* DESCRIPTION*>)><br>
 +
 
 +
Input      Hello World<br>
 +
Output    hello world<br>
 +
 
 +
== TRIM ==
 +
<br>
 +
Syntax    < TRIM(string)><br>
 +
Example < TRIM(<* DESCRIPTION*>)><br>
 +
 
 +
== LTRIM ==
 +
<br>
 +
Syntax    < LTRIM(string)><br>
 +
Example < LTRIM(<* DESCRIPTION*>)><br>
 +
 
 +
== RTRIM ==
 +
<br>
 +
Syntax    < RTRIM(string)><br>
 +
Example < RTRIM(<* DESCRIPTION*>)><br>
 +
 
 +
== TIMESTAMP ==
 +
<br>
 +
Syntax    < TIMESTAMP(format)><br>
 +
Example < TIMESTAMP(dd MM yyyy)><br>
 +
 
 +
== USERNAME ==
 +
<br>
 +
Syntax    < USERNAME()><br>
 +
Example < USERNAME()><br>
 +
 
 +
== VERSION ==
 +
<br>
 +
Syntax    < VERSION()><br>
 +
Example < VERSION()><br>
 +
 
 +
== IIF ==
 +
<br>
 +
Syntax    < IIF(string,string,string,string)><br>
 +
Example < IIF(*CUSTOMER_ID*,SELF,Internal,External)><br>
 +
 
 +
== EXPIRYDATE ==
 +
<br>
 +
Syntax    < EXPIRYDATE(format)><br>
 +
Example < EXPIRYDATE(dd MM yyyy)><br>

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