ApatarForge
  Dashboard > APATAR FUNCTION GUIDES > Apatar Function Guides
  APATAR FUNCTION GUIDES Log In   View a printable version of the current page.  
  Apatar Function Guides
Added by Alex Khizhnyak, last edited by Ludmila Radzevich on Feb 08, 2011  (view change)
Labels: 
(None)

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.


And Function (APATAR FUNCTION GUIDES)
Append Function (APATAR FUNCTION GUIDES)
Begins With Function (APATAR FUNCTION GUIDES)
Boolean Constant Function (APATAR FUNCTION GUIDES)
Clear HTML Function (APATAR FUNCTION GUIDES)
Contain function Guide (APATAR FUNCTION GUIDES)
Copy of Left Trim Function (APATAR FUNCTION GUIDES)
Crop Right Function (APATAR FUNCTION GUIDES)
Current Date Constant Function (APATAR FUNCTION GUIDES)
Date Constant Function (APATAR FUNCTION GUIDES)
Decimal Constant Function (APATAR FUNCTION GUIDES)
Does Not Contain Function (APATAR FUNCTION GUIDES)
Ends With Function (APATAR FUNCTION GUIDES)
Equal Function (APATAR FUNCTION GUIDES)
Equal To Function (APATAR FUNCTION GUIDES)
File Constant Function (APATAR FUNCTION GUIDES)
Generate UUID Function (APATAR FUNCTION GUIDES)
Greater Or Equal Function (APATAR FUNCTION GUIDES)
Greater Than Function (APATAR FUNCTION GUIDES)
Is Credit Number Function (APATAR FUNCTION GUIDES)
Is E-mail Valid Function (APATAR FUNCTION GUIDES)
Is Empty Function (APATAR FUNCTION GUIDES)
Is IP Valid Function (APATAR FUNCTION GUIDES)
Is Not Empty Function (APATAR FUNCTION GUIDES)
Is Not Null Function (APATAR FUNCTION GUIDES)
Is Null Function (APATAR FUNCTION GUIDES)
Is URL Function (APATAR FUNCTION GUIDES)
Left Trim Function (APATAR FUNCTION GUIDES)
Length Function (APATAR FUNCTION GUIDES)
Less Or Equal Function (APATAR FUNCTION GUIDES)
Less Than Function (APATAR FUNCTION GUIDES)
Lower Case Function (APATAR FUNCTION GUIDES)
Match RegExp Function (APATAR FUNCTION GUIDES)
Middle Function (APATAR FUNCTION GUIDES)
Not Function (APATAR FUNCTION GUIDES)
Numeric Constant Function (APATAR FUNCTION GUIDES)
Or Function (APATAR FUNCTION GUIDES)
Pad Left Function (APATAR FUNCTION GUIDES)
Pad Right Function (APATAR FUNCTION GUIDES)
Parse E-mail Body Function (APATAR FUNCTION GUIDES)
Prefix Function (APATAR FUNCTION GUIDES)
Proper Case Function (APATAR FUNCTION GUIDES)
RegExp Function (APATAR FUNCTION GUIDES)
Remove Function (APATAR FUNCTION GUIDES)
Replace If Function (APATAR FUNCTION GUIDES)
Replace With Function (APATAR FUNCTION GUIDES)
Right Trim Function (APATAR FUNCTION GUIDES)
Sentence Case Function (APATAR FUNCTION GUIDES)
Sum Function (APATAR FUNCTION GUIDES)
Text Constant Function (APATAR FUNCTION GUIDES)
Time Constant Function (APATAR FUNCTION GUIDES)
To Boolean Function (APATAR FUNCTION GUIDES)
To Clob Function (APATAR FUNCTION GUIDES)
To Date Function (APATAR FUNCTION GUIDES)
To Decimal Function (APATAR FUNCTION GUIDES)
To Double Function (APATAR FUNCTION GUIDES)
To Int16 Function (APATAR FUNCTION GUIDES)
To Int32 Function (APATAR FUNCTION GUIDES)
To Int64 Function (APATAR FUNCTION GUIDES)
To Single Function (APATAR FUNCTION GUIDES)
To String Function (APATAR FUNCTION GUIDES)
To Time Function (APATAR FUNCTION GUIDES)
Trim Function (APATAR FUNCTION GUIDES)
Upper Case Function Guide (APATAR FUNCTION GUIDES)

Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.
Contact Administrators