Was this helpful?
Function Rule
Function rules () create derived fields to profile to which other rule can be applied. These rules are not useful alone but can be used in combination with rule applied to derived fields. For more information, see Using Function rule in Combination with Other rule.
String Length
 
Description
Calculates the length of a string field populating a derived field.
Parameters
A default name is provided, which you can edit or overwrite by clicking the Field text box.
Supported Data Types
String (input)
Integer (output)
Remarks
String rule also produces a derived field. For more information, see Derived Fields.
String LowerCase
 
Description
Converts all characters in a string field to lowercase.
Parameters
A default name is provided, which you can edit or overwrite by clicking the Field text box.
Supported Data Types
String (input)
String (output)
Remarks
String rule also produces a derived field. For more information, see Derived Fields.
String Trim
 
Description
Trims whitespace from a String field populating a new field.
Parameters
A default name is provided, which you can edit or overwrite by clicking the Field text box.
Supported Data Types
String (input)
String (output)
Remarks
String rule also produces a derived field. For more information, see Derived Fields.
String UpperCase
 
Description
Converts all characters in a string field to uppercase.
Parameters
A default name is provided, which you can edit or overwrite by clicking the Field text box.
Supported Data Types
String (input)
String (output)
Remarks
String rule also produces a derived field. For more information, see Derived Fields.
String Encode Caverphone
 
Description
This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.
Parameters
A default name is provided, which you can edit or overwrite by clicking the Field text box.
Supported Data Types
String (input)
String (output)
Remarks
Coverphone is a phonetic matching algorithm used to identify English names with their sounds.
String rule also produces a derived field. For more information, see Derived Fields and About Coverphone.
String Encode Metaphone
 
Description
This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.
Parameters
A default name is provided, which you can edit or overwrite by clicking the Field text box.
Supported Data Types
String (input)
String (output)
Remarks
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.
String rule also produces a derived field. For more information, see Derived Fields. and About Metaphone.
String Encode Double-Metaphone
 
Description
This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.
Parameters
A default name is provided, which you can edit or overwrite by clicking the Field text box.
Supported Data Types
String (input)
String (output)
Remarks
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.
String rule also produces a derived field. For more information, see Derived Fields and About Double-Metaphone.
String Encode Soundex
 
Description
This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.
Parameters
A default name is provided, which you can edit or overwrite by clicking the Field text box.
Supported Data Types
String (input)
String (output)
Remarks
Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English.
String rule also produces a derived field. For more information, see Derived Fields and About Soundex.
String Encode RefinedSoundex
 
Description
This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.
Parameters
A default name is provided, which you can edit or overwrite by clicking the Field text box.
Supported Data Types
String (input)
String (output)
Remarks
RefinedSoundex phonetically encodes a string using Apache's refined soundex algorithm which is optimized for spell checking words.
String rule also produces a derived field. For more information, see Derived Fields and About RefinedSoundex.
 
Last modified date: 02/09/2024