Regex Field Map

Applies regular expression transformations to map values from a source field to a target field using pattern matching and replacement.

Last updated: June 27, 2025 | Edit this page | Discuss this page

Applies regular expression transformations to map values from a source field to a target field using pattern matching and replacement.

top

Options

ParameterTypeDescriptionDefault Value
ApplyToListA list of Work Item Types that this Field Map will apply to. If the list is empty it will apply to all Work Item Types. You can use “*” to apply to all Work Item Types.missing XML code comments
patternStringGets or sets the regular expression pattern to match against the source field value.missing XML code comments
replacementStringGets or sets the replacement pattern that defines how matched groups should be used to construct the target value.missing XML code comments
sourceFieldStringGets or sets the name of the source field to read data from and apply regex pattern matching.missing XML code comments
targetFieldStringGets or sets the name of the target field to write the regex-transformed data to.missing XML code comments
top

Samples

top

Sample

Sample 

{
  "MigrationTools": {
    "Version": "16.0",
    "CommonTools": {
      "FieldMappingTool": {
        "FieldMaps": [
          {
            "FieldMapType": "RegexFieldMap",
            "ApplyTo": [
              "SomeWorkItemType"
            ],
            "pattern": "PRODUCT \\d{4}.(\\d{1})",
            "replacement": "$1",
            "sourceField": "COMPANY.PRODUCT.Release",
            "targetField": "COMPANY.DEVISION.MinorReleaseVersion"
          }
        ]
      }
    }
  }
}
top

Defaults

Defaults 

{
  "MigrationTools": {
    "Version": "16.0",
    "CommonTools": {
      "FieldMappingTool": {
        "FieldMaps": [
          {
            "FieldMapType": "RegexFieldMap",
            "ApplyTo": [
              "*"
            ]
          }
        ]
      }
    }
  }
}
top

Classic

Classic 

{
  "$type": "RegexFieldMapOptions",
  "sourceField": "COMPANY.PRODUCT.Release",
  "targetField": "COMPANY.DEVISION.MinorReleaseVersion",
  "pattern": "PRODUCT \\d{4}.(\\d{1})",
  "replacement": "$1",
  "ApplyTo": [
    "*",
    "SomeWorkItemType"
  ]
}
top

Metadata

Metadata

Class Name
RegexFieldMap
Status
Missing XML Code Comments
Processing Target
missing XML code comments
Type
FieldMaps
Previous Multi Value Conditional Map
Next Tree To Tag Field Map
Project Information
Azure DevOps Marketplace
Visual Studio Marketplace Stars View Extension
YouTube Channel
Youtube Subscribers Youtube Views
Maintainer

Created and maintained by Martin Hinshelwood of nkdagility.com

Getting Support
Community Support
Questions & Discussions

The first place to look for usage, configuration, and general help.

Commercial Support

We provide training, ad-hoc support, and full service migrations through our professional services.

Azure DevOps Migration Services
Documentation