Preface
Introduction to Data Transformation
- Data Transformation Overview
- Data Transformation Process Architecture
- Data Transformation Components
Data Processor Transformation
- Data Processor Transformation Overview
- Data Processor Transformation Views
- Data Processor Transformation Ports
- Startup Component
- References
- Data Processor Transformation Settings
- Events
  - Event Types
  - Data Processor Events View
- Logs
- Data Processor Transformation Development
- Data Processor Transformation Export and Import
- Data Processor Transformation Validation
  - Using a Speed-enhanced Data Transformation Engine for VRL Validations
- Data Processor Transformation in a Non-native Environment
Wizard Input and Output Formats
- Wizard Input and Output Formats Overview
- COBOL Processing Library
- JSON
- XML
  - Creating a Transformation that Transforms XML
Relational Input and Output
- Relational Input and Output Overview
- Relational Input
- Relational Output
Using the IntelliScript Editor
- IntelliScript Editor Overview
  - Creating a Script
- Opening an IntelliScript Editor
- Editing Procedures
- IntelliScript Editor Menus
XMap
- XMap Overview
- XMap Schemas
- Mapping Statements
- XPath Expressions
- XMap Variables
  - Creating a Variable in the XMap Editor
- XMap Example
Libraries
- Libraries Overview
- Library Structure
- Element Properties
- Library Management
- Edit Libraries with the Library Editor
- Edit Libraries with the IntelliScript Editor
Schema Object
- Schema Object Overview
- Schema Files
- Schema Object Overview View
- Schema Object Schema View
- Schema Object Advanced View
- Creating a Schema Object
- Schema Updates
  - Schema Synchronization
  - Schema File Edits
    - Setting a Default Schema File Editor
    - Editing a Schema File
Command Line Interface
- Command Line Interface Overview
- CM_console
Scripts
- Scripts Overview
- Script Components
- Script Component Properties
- Script Startup Components
  - Setting the Startup Component with the IntelliScript Editor
- Example Sources
- IntelliScript Editor
- Validate a Script
- Sample Scripts
  - Importing a Sample Script
Parsers
- Parsers Overview
- Platform-Independent Parsers
  - Newline Markers
  - File Paths
- Parser Component Reference
  - Parser
Script Ports
- Script Ports Overview
- Script Port Component Reference
Document Processors
- Document Processors Overview
- Defining a Document Processor
  - Display of Document Processor Output
- Document Processor Component Reference
- TextML XML Schema
- PdfToTxt_4 Table Configuration Editor
  - Editor Options
  - PDF Conversion Example
    - Configuring the First Table
    - Configuring the Second Table
Formats
- Formats Overview
- Standard Format Properties
- Format Component Reference
- Delimiters Component Reference
- Format Preprocessor Component Reference
  - HtmlProcessor
  - RtfProcessor
Data Holders
- Data Holders Overview
- XML Schemas
- Using a Schema to Map Anchors
- Generating Valid XML
  - Role of Schemas in Parsing
  - Role of Schemas in Serialization and Mapping
- Variables
- Variable Component Reference
  - Variable
- Multiple-Occurrence Data Holders
Anchors
- Anchors Overview
- Mapping Content Anchors to Data Holders
- Defining Anchors
- Standard Anchor Properties
- How a Parser Searches for Anchors
- Anchor Component Reference
- Searcher Component Reference
- Anchor Subcomponent Reference
Transformers
- Transformers Overview
- Defining Transformers
- Standard Transformer Properties
- Transformer Component Reference
Actions
- Actions Overview
- Standard Action Properties
- Action Component Reference
- Action Subcomponent Reference
Serializers
- Serializers Overview
- Serialization Anchors
  - Example of Serialization Anchors
  - Sequence of Serialization Anchors
- Standard Serializer Properties
- Serializer Component Reference
  - Serializer
- Serialization Anchor Component Reference
Mappers
- Creating a Mapper
- Components Nested within a Mapper
- Mapper Example
- Standard Mapper Properties
- Mapper Component Reference
  - Mapper
- Mapper Anchor Component Reference
Locators, Keys, and Indexing
- Overview of Locators, Keys, and Indexing
- Example of Locators
- Example of Indexing by Key
- Source and Target Properties
  - Source Property
  - Target Property
- Standard Locator and Key Properties
- Locator and Key Component Reference
Streamers
- Streamers Overview
- Text Streamers
- XML Streamers
- Standard Streamer Properties
- Streamer Component Reference
- Streamer Subcomponent Reference
Validators, Notifications, and Failure Handling
- Overview of Validators, Notifiers, and Failure Handling
- Failure Handling
  - Using the Optional Property to Handle Failures
  - Writing a Failure Message to the User Log
    - Configuring User Log Output
    - Viewing the User Log
- Validators
- Standard Validator Properties
- Validator Component Reference
- Notifications
- Notification Component Reference
Validation Rules
- Validation Rules Overview
- Validation Rules Element Reference
- Edit the Validation Rules in an External Editor
- Create a Validation Rules Object
- Import a Data Transformation Service with Validation Rules
Custom Script Components
- Custom Script Components Overview
- Custom Component Example
- Custom Component Properties
- Developing a Custom Component
  - Java Interface Example
  - Sample Custom Java Components
- Configuring a Custom Component
  - Sample Scripts Containing Custom Components

User Guide

10.5
- 10.5.2
- 10.4.0

Back Next

JavaScript Extensions

The JavaScript processor implements the following methods that are not defined in standard JavaScript. You can use these extensions in any location where the Script accepts a JavaScript expression.

Most of the functions are JavaScript implementations of transformers or actions.

extra.sum(number1, number 2, ...): Returns the sum of the parameters.
extra.allSame(param1, param2, ...): Returns true if all the parameters have the same value.
lookup.<lookup_name>(key): This function accesses a global lookup table by name.

In the Script, define a global
InlineTable
or
XMLLookupTable
. Then, in a JavaScript expression, you can access the table. For example, if you define a global
InlineTable
called
USPresidents
,
lookup.USPresidents(1)
returns
George Washington
.

For more information, see LookupTransformer.
extra.formatDate(date, input_format, output_format): Formats a date or time. For more information, see DateFormatICU.
extra.substitute(text, oldSubstring, newSubstring, useRegex): Replaces all instances of a substring with another substring. If
useRegex
is true, the method interprets
oldSubstring
as a regular expression.
extra.formatNumber(number, size_of_integer_part, number_of_decimals, sign, insert_decimal_point, unit_type): Formats a number. For more information, see FormatNumber.
extra.insertString(text, injections_place, string_to_inject): Inserts a string into the text. For more information, see InjectString.
extra.formatTransformationStartTime(format): Outputs the date and/or time at which the transformation started running. For more information, see TransformationStartTime.
extra.resize(text, size, padding_character, align): Fits the input text to a specified size, padding or truncating as required. For more information, see Resize.
extra.dateAdd(date_format, date, days_to_add): Increments a date by a given number of days. For more information about the
date_format
, see DateFormatICU.
extra.dateAddMonths(date_format, date, months_to_add): Increments a date by a given number of months. For more information about the
date_format
, see DateFormatICU.
extra.dateAddYears(date_format, date, years_to_add): Increments a date by a given number of years. For more information about the
date_format
, see DateFormatICU.
extra.dateDiff(date_format1, date1, date_format2, date2): Computes the difference between two dates. For more information, see DateDiffICU.
extra.createGuid(0): Generates a GUID identifier. For more information, see CreateGuid. You must supply a parameter value such as 0.
extra.upper(text) , extra.lower(text) , extra.capitalize(text): Changes the text to all upper case, all lower case, or only the first letter capitalized. For more information, see ChangeCase
extra.rtl2ltr(text): Reverses a string written in a right-to-left language to left-to-right. For more information, see hebrewBidi.
extra.trim(text): Deletes leading and trailing space characters from the text. For more information, see RemoveMarginSpace.

EnsureCondition

Rename Saved Search

Table of Contents

User Guide

User Guide

JavaScript Extensions

JavaScript Extensions