Grooper Help - Version 25.0
25.0.0017 2,127
  • Overview
  • Help Status

Parse Value

Data Action Grooper.Core

Parses a field value into substrings using a regular expression and assigns them to sibling fields.

Remarks

The ParseValue action is used to extract subcomponents from a field's value and copy them to other fields.


Usage

  • Add a ParseValue action to a Data Rule to automate parsing and distribution of field values.
  • Configure the 'SourceField' property to specify the input field to parse.
  • Set the 'Pattern' property to a regular expression with named groups matching the target fields.

How it works

  1. The regular expression in 'Pattern' is applied to the value of 'SourceField'.
  2. Each named group in the regex should correspond to a sibling field (including the source field itself, if desired).
  3. The value captured by each group is assigned to the field with the matching name (spaces replaced by underscores).

Example

Suppose you have a field "Full Name" with the value DOE, JOHN Q and want to split it into "Last Name", "First Name", and "MI":

  • Set 'SourceField' to "Full Name".
  • Set 'Pattern' to (?<Last_Name>[A-Z]+), (?<First_Name>[A-Z]+) (?<MI>[A-Z])

This will copy "DOE" to "Last Name", "JOHN" to "First Name", and "Q" to "MI".


Related Concepts

  • Data Field: Represents a field in the data model.
  • Data Rule: Hosts and executes data actions such as ParseValue.

For more information, see the documentation for Data Rule, Data Field, and related data extraction objects.

Properties

NameTypeDescription
General
Info

See Also

Used By

Notification