 | These guides explain how to use Apatar function modules. |
Boolean
And Function - Transform, validate, or filter data using a logical AND operator, i.e. if both of two conditions are TRUE, the records will be returned.
Is Not Null Function - Filter out the records with NULL fields, i.e. fields with uninitialized entry or unknown data value.
Is Null Function - The function helps filter your data and output the records with NULL fields, i.e. fields with uninitialized entry or unknown data value.
Not Function - The function is employed to invert the result of a comparison or logical expression.
Or Function - Transform, validate, or filter data using a logical OR operator, i.e. if any of two conditions is TRUE, the records will be returned.
To Boolean Function - The function converts strings or numbers into Boolean values (TRUE/FALSE).
To String Function - Convert any values (numbers, dates, etc.) into text strings using this function.
Constant
Boolean Constant Function - Set a boolean constant value for fields of a related type.
Current Date Constant Function - Retrieves the current date in the Date format.
Date Constant Function - Set a date constant value for fields of a related type.
Decimal Constant Function - Set a desired decimal constant value (0.000...).
File Constant Function - Choose a desired file and use its path as a constant value.
Numeric Constant Function - Use this function to set a desired numeric constant value for integer fields.
Text Constant Function - Set a string (text) constant value for related type of fields.
Time Constant Function - Transform, filter, or validate your data using a desired time constant value.
Date and Time
Equal Function - Filter out the records that are not equal to a certain value.
Equal To Function - Find the records with two equal fields using this function.
Greater Or Equal Function - Grab the records that are greater or equal to a specified value.
Greater Than Function - Perform comparison-based filtering with this function.
Is Not Null Function - Filter out the records with NULL fields, i.e. fields with uninitialized entry or unknown data value.
Is Null Function - Use this function to filter your data and output the records with NULL fields, i.e. fields with uninitialized entry or unknown data value.
Less Or Equal Function - Filter, transform, or validate the records that are less or equal to a specified value.
Less Than Function - Filter your data and output the records that are less than a specified value.
To Date Function - Convert strings into date values using this function.
To String Function - Convert any values (numbers, dates, etc.) into text strings using this function.
To Time Function - Use this function to convert strings into time values.
Number
Equal Function - Filter out the records that are not equal to a certain value.
Equal To Function - Find the records with two equal fields using this function.
Greater Or Equal Function - Grab the records that are greater or equal to a specified value.
Greater Than Function - Perform comparison-based filtering with this function.
Is Not Null Function - Filter out the records with NULL fields, i.e. fields with uninitialized entry or unknown data value.
Is Null Function - The function helps filter your data and output the records with NULL fields, i.e. fields with uninitialized entry or unknown data value.
Less Or Equal Function - Filter, transform, or validate the records that are less or equal to a specified value.
Less Than Function - Filter your data and output the records that are less than a specified value.
Sum Function - Use this function to sum up two integer values or to add up a given constant to an integer value.
To Boolean Function - The function is used to convert strings or numbers into Boolean values (TRUE/FALSE).
To Decimal Function - Convert strings or integer numbers into decimal values.
To Double Function - Convert integer or decimal numbers into the values of double-precision data type (floating-point numbers) using this function.
To Int16 Function - Convert integer numbers into the values of the Int16 data type (-32,678 to +32,767).
To Int32 Function - Convert integer numbers into the values of the Int32 data type (-2,147,483,648 to 2,147,483,647).
To Int64 Function - Convert integer numbers into the values of the Int64 data type (-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807).
To Single Function - Convert integer numbers into the values of the single byte data type.
To String Function - Convert any values (numbers, dates, etc.) into text strings using this function.
String
Generate UUID Function (NEW!) - Generate automatically a Universally Unique Identifier (UUID) using this function.
Append Function - Use this function to append text to the end of a source string.
Begins With Function - Filter your data and output the records containing the field values that begin with a certain string.
Clear HTML Function - Remove HTML tags from extracted text with Apatar.
Concatenate Function - Merge two strings into a single one using this function.
Contain Function - Find the records that contain a desired text string.
Crop Right Function - Employ this function to crop text from the right side of a string.
Does Not Contain Function - Filter out the records that contain a certain text.
Ends With Function - Filter your records and output those containing the field values that end with a certain string.
Equal Function - Filter out the records that are not equal to a certain value.
Equal To Function - Find the records with two equal fields using this function.
Greater Or Equal Function - Grab the records that are greater or equal to a specified value.
Greater Than Function - Perform comparison-based filtering with this function.
Is Credit Number Function - Use this function to check the validity of a credit card number. (The function doesn't validate the credit card itself, it just ensures that a value is entered in a credit card number format.)
Is E-mail Valid Function - Filter out the strings that are entered in invalid e-mail address formats.
Is Empty Function - Filter your data and output the records with empty string fields.
Is IP Valid Function - Filter out the strings that contain invalid IP address formats. The function is based on validation with Regular Expressions.
Is Not Empty Function - Filter out the records with an empty field.
Is Not Null Function - Filter out the records with NULL fields, i.e. fields with uninitialized entry or unknown data value.
Is Null Function - The function helps filter your data and output the records with NULL fields, i.e. fields with uninitialized entry or unknown data value.
Is URL Function - Filter out the strings that contain URL addresses entered in invalid format.
Left Trim Function - Employ this function to remove extra blank space (if any) from the left side of a string.
Length Function - Count a number of characters in the specified text strings using this Apatar function.
Less Or Equal Function - Filter, transform, or validate the records that are less or equal to a specified value.
Less Than Function - Filter your data and output the records that are less than a specified value.
Lower Case Function - Convert all characters of a record to lower case.
Match RegExp Function - Identify strings that match a specified Regular Expression.
Middle Function - Use this function if you need to truncate text strings from both sides.
Pad Left Function - Add a required number of blank spaces to the left side of a string.
Pad Right Function - Add a required number of blank spaces to the right side of a string.
Parse E-mail Body Function - Retrieve the text of an e-mail body, omitting the headers and other system information.
Prefix Function - Employ this function when you need to add a required text prefix at the beginning of a string in a specified field.
Proper Case Function - Capitalize the first character of every word in the text string and convert the rest of the characters to lower case.
RegExp Function - Apply a Regular Expression to input field values.
Remove Function - Use this function to remove a specified text from a string.
Replace Function - Replace text value with another one during transformation.
Replace With Function - Replace multiple field values with new ones using this function.
Right Trim Function - Remove extra blank spaces (if any) from right side of a string.
Sentence Case Function - Capitalize the first letter of a string and convert the rest of the text to lower case.
To Boolean Function - The function is used to convert strings into Boolean values.
To Clob Function - Convert values into clob
To Date Function - Convert strings into date values using this function.
To Decimal Function - Convert strings into decimal values.
To String Function - Convert any values (numbers, dates, etc.) into text strings using this function.
To Time Function - Use this function to convert strings into time values.
Trim Function - Remove extra blank spaces (if any) from both the right and left sides of a string.
Upper Case Function - Convert every character of a speciried string to upper case.
