Label Functions: Difference between revisions
No edit summary |
No edit summary |
||
| (3 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 == | ||
Latest revision as of 14: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)>