Difference between revisions of "Label Functions"
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 == | ||
− | < | + | 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 == |
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)>