FieldMaps : RegexFieldMap

Ref

  

Less than 1 minute to read

  

2025-06-19 13:46:05 +0000

draft

This page is in draft and may include errors or omissions. Please check the discussions for any pending updates and changes to the content or to suggest your own changes.

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

Options

Parameter name	Type	Description	Default Value
ApplyTo	List	A 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
pattern	String	Gets or sets the regular expression pattern to match against the source field value.	missing XML code comments
replacement	String	Gets or sets the replacement pattern that defines how matched groups should be used to construct the target value.	missing XML code comments
sourceField	String	Gets or sets the name of the source field to read data from and apply regex pattern matching.	missing XML code comments
targetField	String	Gets or sets the name of the target field to write the regex-transformed data to.	missing XML code comments

Examples

sample

This is an example of what your config might look like once configured.

    {
  "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"
          }
        ]
      }
    }
  }
}
    

defaults

These are the default values for this configuration. If you do not set it in your config the default always applies. You can overide by adding a diferent value in your config.

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

classic

We have moved to a new config format, and you will need to update your old configs. This entry is a strate seralisation of the object and is here for legacy, and may provide value for debugging issues.

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