Difference between revisions of "Label Functions"
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== SUBSTRING == | == 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> |
| + | |||
Syntax <SUBSTRING(string,start,len)><br> | Syntax <SUBSTRING(string,start,len)><br> | ||
Example <SUBSTRING(<*SSCC*>,1,3)><br> | Example <SUBSTRING(<*SSCC*>,1,3)><br> | ||
| + | |||
| + | Input 350001611234567890<BR> | ||
| + | Output 350<BR> | ||
== LEFT == | == 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> | Syntax <LEFT(string,len)><br> | ||
| − | Example <LEFT(<*SSCC*>, | + | Example <LEFT(<*SSCC*>,5)><br> |
| + | |||
| + | Input 350001611234567890<BR> | ||
| + | Output 35000<BR> | ||
== RIGHT == | == 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> | Syntax < RIGHT(string,len)><br> | ||
| − | Example < RIGHT(<*SSCC*>, | + | Example < RIGHT(<*SSCC*>,6)><br> |
| + | |||
| + | Input 350001611234567890<BR> | ||
| + | Output 567890<BR> | ||
== PADLEFT == | == PADLEFT == | ||
| − | < | + | This function allows you to pad out the size of string using a nominated character to the left of the original string<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> | ||
| + | |||
| + | Input 25<BR> | ||
| + | Output 0025<BR> | ||
== PADRIGHT == | == PADRIGHT == | ||
| − | < | + | This function allows you to pad out the size of string using a nominated character to the left of the original string<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> | ||
| + | |||
| + | Input 25<BR> | ||
| + | Output 2500<BR> | ||
== UPPERCASE == | == UPPERCASE == | ||
| − | < | + | 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 == | ||
| − | < | + | 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 == | ||
| Line 61: | Line 84: | ||
== VERSION == | == VERSION == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < VERSION()><br> |
| − | Example < | + | Example < VERSION()><br> |
== IIF == | == IIF == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < IIF(string,string,string,string)><br> |
| − | Example < | + | Example < IIF(*CUSTOMER_ID*,SELF,Internal,External)><br> |
== EXPIRYDATE == | == EXPIRYDATE == | ||
<br> | <br> | ||
| − | Syntax < EXPIRYDATE()><br> | + | Syntax < EXPIRYDATE(format)><br> |
Example < EXPIRYDATE(dd MM yyyy)><br> | Example < EXPIRYDATE(dd MM yyyy)><br> | ||
Latest revision as of 13:15, 7 March 2014
Contents
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)>
