Difference between revisions of "Label Functions"

Revision as of 14:06, 7 March 2014

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 < 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)>