Difference between revisions of "Label Functions"
| Line 7: | Line 7: | ||
<br> | <br> | ||
Syntax <LEFT(string,len)><br> | Syntax <LEFT(string,len)><br> | ||
| − | + | Example <LEFT(<*SSCC*>,3)><br> | |
== RIGHT == | == RIGHT == | ||
<br> | <br> | ||
Syntax < RIGHT(string,len)><br> | Syntax < RIGHT(string,len)><br> | ||
| − | + | Example < RIGHT(<*SSCC*>,3)><br> | |
== PADLEFT == | == PADLEFT == | ||
<br> | <br> | ||
Syntax < PADLEFT(string,len,char)><br> | Syntax < PADLEFT(string,len,char)><br> | ||
| − | + | Example < PADLEFT(<* PROD_QUANTITY*>,4,0)><br> | |
== PADRIGHT == | == PADRIGHT == | ||
<br> | <br> | ||
Syntax < PADRIGHT(string,len),char><br> | Syntax < PADRIGHT(string,len),char><br> | ||
| − | + | Example < PADRIGHT(<*PROD_QUANTITY*>,4,)><br> | |
== UPPERCASE == | == UPPERCASE == | ||
<br> | <br> | ||
Syntax < UPPERCASE(string)><br> | Syntax < UPPERCASE(string)><br> | ||
| − | + | Example < UPPERCASE(<*DESCRIPTION*>)><br> | |
== LOWERCASE == | == LOWERCASE == | ||
<br> | <br> | ||
Syntax < LOWERCASE(string)><br> | Syntax < LOWERCASE(string)><br> | ||
| − | + | Example < LOWERCASE(<* DESCRIPTION*>)><br> | |
== TRIM == | == TRIM == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < TRIM(string)><br> |
| − | + | Example < TRIM(<* DESCRIPTION*>)><br> | |
== LTRIM == | == LTRIM == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < LTRIM(string)><br> |
| − | + | Example < LTRIM(<* DESCRIPTION*>)><br> | |
== RTRIM == | == RTRIM == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < RTRIM(string)><br> |
| − | + | Example < RTRIM(<* DESCRIPTION*>)><br> | |
== TIMESTAMP == | == TIMESTAMP == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < TIMESTAMP(format)><br> |
| − | + | Example < TIMESTAMP(dd MM yyyy)><br> | |
== USERNAME == | == USERNAME == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < USERNAME()><br> |
| − | + | Example < USERNAME()><br> | |
== VERSION == | == VERSION == | ||
<br> | <br> | ||
| − | Syntax < RIGHT( | + | Syntax < RIGHT()><br> |
| − | + | Example < RIGHT()><br> | |
== IIF == | == IIF == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < VERSION()><br> |
| − | + | Example < VERSION()><br> | |
== EXPIRYDATE == | == EXPIRYDATE == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < EXPIRYDATE()><br> |
| − | + | Example < EXPIRYDATE(dd MM yyyy)><br> | |
Revision as of 13:03, 7 March 2014
Contents
SUBSTRING
Syntax <SUBSTRING(string,start,len)>
Example <SUBSTRING(<*SSCC*>,1,3)>
LEFT
Syntax <LEFT(string,len)>
Example <LEFT(<*SSCC*>,3)>
RIGHT
Syntax < RIGHT(string,len)>
Example < RIGHT(<*SSCC*>,3)>
PADLEFT
Syntax < PADLEFT(string,len,char)>
Example < PADLEFT(<* PROD_QUANTITY*>,4,0)>
PADRIGHT
Syntax < PADRIGHT(string,len),char>
Example < PADRIGHT(<*PROD_QUANTITY*>,4,)>
UPPERCASE
Syntax < UPPERCASE(string)>
Example < UPPERCASE(<*DESCRIPTION*>)>
LOWERCASE
Syntax < LOWERCASE(string)>
Example < LOWERCASE(<* DESCRIPTION*>)>
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 < RIGHT()>
Example < RIGHT()>
IIF
Syntax < VERSION()>
Example < VERSION()>
EXPIRYDATE
Syntax < EXPIRYDATE()>
Example < EXPIRYDATE(dd MM yyyy)>
