Difference between revisions of "Label Functions"
Line 16: | Line 16: | ||
== PADLEFT == | == PADLEFT == | ||
+ | <br> | ||
+ | Syntax < PADLEFT(string,len,char)><br> | ||
+ | example < PADLEFT(<* PROD_QUANTITY*>,4,0)><br> | ||
== PADRIGHT == | == PADRIGHT == | ||
+ | <br> | ||
+ | Syntax < PADRIGHT(string,len),char><br> | ||
+ | example < PADRIGHT(<*PROD_QUANTITY*>,4,)><br> | ||
+ | |||
== UPPERCASE == | == UPPERCASE == | ||
+ | <br> | ||
+ | Syntax < UPPERCASE(string)><br> | ||
+ | example < UPPERCASE(<*DESCRIPTION*>)><br> | ||
+ | |||
== LOWERCASE == | == LOWERCASE == | ||
+ | <br> | ||
+ | Syntax < RIGHT(string,len)><br> | ||
+ | example < RIGHT(<*SSCC*>,3)><br> | ||
+ | |||
== TRIM == | == TRIM == | ||
+ | <br> | ||
+ | Syntax < RIGHT(string,len)><br> | ||
+ | example < RIGHT(<*SSCC*>,3)><br> | ||
+ | |||
== LTRIM == | == LTRIM == | ||
+ | <br> | ||
+ | Syntax < RIGHT(string,len)><br> | ||
+ | example < RIGHT(<*SSCC*>,3)><br> | ||
+ | |||
== RTRIM == | == RTRIM == | ||
+ | <br> | ||
+ | Syntax < RIGHT(string,len)><br> | ||
+ | example < RIGHT(<*SSCC*>,3)><br> | ||
+ | |||
== TIMESTAMP == | == TIMESTAMP == | ||
+ | <br> | ||
+ | Syntax < RIGHT(string,len)><br> | ||
+ | example < RIGHT(<*SSCC*>,3)><br> | ||
+ | |||
== USERNAME == | == USERNAME == | ||
+ | <br> | ||
+ | Syntax < RIGHT(string,len)><br> | ||
+ | example < RIGHT(<*SSCC*>,3)><br> | ||
+ | |||
== VERSION == | == VERSION == | ||
+ | <br> | ||
+ | Syntax < RIGHT(string,len)><br> | ||
+ | example < RIGHT(<*SSCC*>,3)><br> | ||
+ | |||
== IIF == | == IIF == | ||
+ | <br> | ||
+ | Syntax < RIGHT(string,len)><br> | ||
+ | example < RIGHT(<*SSCC*>,3)><br> | ||
+ | |||
== EXPIRYDATE == | == EXPIRYDATE == | ||
+ | <br> | ||
+ | Syntax < RIGHT(string,len)><br> | ||
+ | example < RIGHT(<*SSCC*>,3)><br> |
Revision as of 12:58, 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 < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
TRIM
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
LTRIM
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
RTRIM
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
TIMESTAMP
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
USERNAME
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
VERSION
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
IIF
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
EXPIRYDATE
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>