Filter
Top Products
• Proper – Convert string to proper case, based on windows settings.
• Left – Returns left(x) characters from a string, where x is the number of
characters.
o Parameters: Length
• Right – Returns right(x) characters from a string, where x is the number of
characters.
• Parameters: Length
• Mid – Returns a portion of a string, based on a supplied starting position and
number of characters
o Parameters: Starting Position, Length
• Translate – Used to convert one string value to another (for example used to
convert string “IN” to “Invoice”)
• Parameters: Search String, Replacement String; Comma separated strings (for
example: “INCMDM”, “Invoice,Credit Memo,Debit Memo”)
• ToString – Converts a value to a string
• ToNumber – Converts a value to a number
• ToDate – Converts a value to a date
• Now – Return the current system date and time
• TF<->YN – Converts TF to YN respectively
• LookUp – Used to retrieve a value from the SalesLogix database, based on a
value from the ERP System
o Parameters: Lookup Table, Lookup Key, Return Field
• ParseName – Used to parse a single name field, into First, Last, Middle, Prefix,
and Suffix
o Parameters: Name Part, 0=First, 1=Last, 2=Middle, 3=Prefix, 4=Suffix
• State Name – Returns the complete State Name from an abbreviation
Page 24 of 45