Difference between revisions of "Label Functions"
| (12 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | == | + | == 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> | |
| + | 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> | ||
| − | + | 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> | ||
| − | + | 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
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)>
