Mapper Function List

String

• CONST - Outputs the defined constant
• CONCATENATE - Concatenates several strings into a single string
• InsertString - Inserts a string
• DeleteString - Deletes part of the input string
• LEFT - Outputs the left portion of a string
• MID - Returns the middle portion of a string
• RIGHT - Outputs the right portion of a string
• StringReplace - Replaces a part of the input string
• EXTSTR - Extracts a substring from the input string
• TRUNCATE - Truncates a string
• TRIM - Trims the white space from either end of a string
• LEN - Returns the length of a string
• REPT - Concatenates a string n times
• EMBED - Embeds data into a string
• UPPER - Converts each character in a string to the set locale's upper case
• LOWER - Converts characters in a string to the set locale's lower case
• JIS - Converts half-width characters to full-width characters
• ASC - Converts recognized full-width characters to half-width
• FILENAME - Returns the file name or path portion of the input path
• UUID - Creates a Universally Unique Identifier (UUID)
• Split - Split input string
• StrCompare - Compare string

RegExp

• RegexpMatch - Outputs the result of regular expression pattern matching
• RegexpFind - Outputs the index position of the specified string in the input stream
• REGEXP - Outputs a portion of a string that matches the set regular expression
• REGEXPREPLACE - Replaces portions of a string matching the set regular expression

Number

• Add - Adds two numbers
• Subtract - Subtracts the second input from the first input
• Divide - Performs the division operation on the inputs
• Multiply - Multiplies the inputs together
• Mod - Calculates the remainder after division
• Sum - Performs the set mathematical calculation
• Min - Performs the set mathematical calculation
• Max - Performs the set mathematical calculation
• Average - Performs the set mathematical calculation
• Round - Rounds the input
• Abs - Returns the input's absolute value
• Rand - Generates a random number
• FORMATDECIMAL - Converts the input numerical value to the set decimal format

Date

• NOW - Outputs the current date and time
• STRTODATE - Parses a pre-formatted string for date and time
• FORMATDATE - Formats the input DateTime string
• DATECALC - Modifies the input date and time string
• DateSplit - Split input date
• DateTimeEx - Creates a date and time string
• Holiday - check holiday

Binary

• CONSTB - Outputs a binary constant
• CONCATENATEB - Concatenates several bytes into a single bytes
• LEFTB - Outputs the left portion, in bytes, of the input stream
• MIDB - Outputs the middle portion, in bytes, of the input stream
• RIGHTB - Outputs the right portion, in bytes, of the input stream
• REPLACEB - Replaces a portion of the input stream
• TRUNCATEB - Truncates input data
• LENB - Outputs the length, in bytes, of the input

Control

• IF - Compares the inputs against the set condition, then outputs the result
• CHOICE - Chooses which input to direct as output
• NullCheck - Outputs the first non-Null input
• JavaInterpreter - Executes JAVA code
• SubFunction - Sub-Function
• FunctionInvoker - FunctionInvoker
• FileExist - Check file exists

Converter

• TABLE - Returns data from a CSV or Properties file
• TABLEDB - Outputs the results of a database query
• RangeTable - Returns data from a CSV range file
• TABLESTREAM - Returns data from a stored Stream
• FORMATNUMBER - Converts the input numeric value to the set string format
• FORMATCURRENCY - Converts the input string to the set country's currency
• FORMATPERCENT - Formats the input numeric value to the set country's percent String representation
• ENCODE - Encodes the input according to the set algorithm
• DECODE - Decodes the data according to the set algorithm
• DIGEST - Converts the data to it's digest form
• URLENCODE - Converts the input to the x-www-form-url encoding format
• URLDECODE - Decodes the x-www-form-url formatted input
• CONVERT - Converts the input to another encoding format
• NullConverter - Null Convert

Boolean

• AND - and
• OR - or
• NOT - not
• Equal - ==
• NotEqual - !=
• Greater - >
• GreaterEqual - >=
• Less - <
• LessEqual - <=
• SelectIndex - SelectIndex
• BoolIf - Bool if

MIME

• MailAddressParser - Outputs the addresses or names parsed from the input mail list
• MailAddressExclude - Deletes the exclusion mail address from the input address list
• MailAddressCount - Outputs the number of addresses in the input mail list
• MIMEParameterParser - Outputs parameter values from the input MIME header

Other

• CellCalc - Calc cell position