Rule Name | Description |
|---|---|
Phonetically encodes the string field using the specified algorithm. | |
Converts a given string field into a specified data type. It creates a new in-memory field. |
Description | Phonetically encodes the string field using the specified algorithm. |
Parameters | • Algorithm - The encoding algorithm: – Soundex - This is a phonetic algorithm for indexing names by sound, as pronounced in English. – RefinedSoundex - RefinedSoundex phonetically encodes a string using Apache's refined soundex algorithm which is optimized for spell checking words. – Caverphone - Coverphone is a phonetic matching algorithm used to identify English names with their sounds. – Metaphone - Metaphone is a phonetic algorithm, for indexing words by their English pronunciation. It improves on the Soundex algorithm by using information about variations and inconsistencies in English spelling and pronunciation. – DoubleMetaphone - Double Metaphone algorithm in contrary to the Metaphone algorithm whose application is limited to English only, takes into account spelling peculiarities of a number of other languages. • Derived Field Name - The name of the in-memory derived field. A default name is provided, however, you can edit or overwrite it. |
Supported Data Types | • String (input) • String (output) |
Remarks | Provides pass and fail statistics and generates a derived field. See Derived Fields. |
Description | Converts a given string field into a specified data type. It creates a new in-memory field (see Derived Fields). |
Parameters | • Derived Field Name - The name of the derived in-memory field. A default name is provided, however, you can edit or overwrite it. • Convert To - The data type of the derived in-memory field: – Date – Time – TimeStamp – Boolean – Numeric – Double – Float – Long – Int When converting to Date derived field, the following parameter is required: • Format - The format of the Date derived field. You can select from the available options or specify your own pattern in the text box. See DateTime Format. – yyyy-M-dd – yyyy-MM-dd – MM/dd/yy – M/dd/yyyy – MM/dd/yyyy – M-dd-yyyy – MM-dd-yyyy – MMM-yy – MMM dd, yyyy |
When converting to Time derived field, the following parameter is required: • Format - The format of the Time derived field. You can select from the available options or specify your own pattern in the text box. See DateTime Format. – HH:mm:ss – HH:mm – hh:mm:ss – hh:mm aa When converting to TimeStamp derived field, the following parameters are required: • Format - The format of the TimeStamp derived field. You can select from the available options or specify your own pattern in the text box. See DateTime Format. – yyyy-MM-dd HH:mm:ss – MM/dd/yyyy HH:mm – MMM dd, yyyy HH:mm aa – EEE, dd MMM yyyy HH:mm:ss Z Note: - ISO 8601 format should be mentioned as yyyy-MM-dd'T'HH:mm:ss+hh:mm. T in this format must be enclosed within single quotes, 'T'. • Time Zone - Select your time zone from the available options. When converting to Boolean derived field, the following parameters are required: • Format - The format of the Boolean derived field: – True.False – Yes.No – 1.0 – T.F When converting to Numeric, Double, Float, Long, and Int derived field, there are no parameters to specify. | |
Supported Data Types | • String (input) • Date, Time, TimeStamp, Boolean, Numeric, Double, Float, Long, Int (output) |
Remarks | Provides pass and fail statistics and generates a derived field. See Derived Fields. |