Legacy Product

Fusion 5.10
    Fusion 5.10

    Regex Field Replacement Index Stage

    Table of Contents

    The Regex Field Replacement index stage lets you match against a source field and append or overwrite that field or another one with a replacement string. It uses the java.util.regex library.

    One notable feature is support for flags in the prefix of the pattern, such as (?iu)\w+ where the i flag means case-insensitive and u means Unicode-aware case folding. You can also configure the desired behavior when there is no match. Additionally, you can use capture groups in your replacement configuration using $1 to denote the first capture group.

    Configuration

    When entering configuration values in the UI, use unescaped characters, such as \t for the tab character. When entering configuration values in the API, use escaped characters, such as \\t for the tab character.

    This stage allows you to replace text using regular expressions

    skip - boolean

    Set to true to skip this stage.

    Default: false

    label - string

    A unique label for this stage.

    <= 255 characters

    condition - string

    Define a conditional script that must result in true or false. This can be used to determine if the stage should process or not.

    rules - array[object]

    object attributes:{source required : {
     display name: Source Fields
     type: array
    }    target : {
     display name: Target Field
     type: string
    }    writeMode : {
     display name: Write Mode
     type: string
    }    pattern required : {
     display name: Regex Pattern
     type: string
    }    returnIfNoMatch : {
     display name: Return if no Match
     type: string
    }    noMatchValue : {
     display name: No Match Literal Value
     type: string
    }    replacement required : {
     display name: Regex Replacement
     type: string
    }    replaceWhich : {
     display name: Replace Which
     type: string
    }    }