String Manipulator Tool

Used to process the String fields of a work item. This is useful for cleaning up data. It will limit fields to a max length and apply regex replacements based on what is configured. Each regex replacement is applied in order and can be enabled or disabled.

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

Used to process the String fields of a work item. This is useful for cleaning up data. It will limit fields to a max length and apply regex replacements based on what is configured. Each regex replacement is applied in order and can be enabled or disabled.

top

Options

Parameter Type Description Default Value
Enabled Boolean If set to true then the tool will run. Set to false and the processor will not run. missing XML code comments
Manipulators List List of regex based string manipulations to apply to all string fields. Each regex replacement is applied in order and can be enabled or disabled. {}
MaxStringLength Int32 Max number of chars in a string. Applied last, and set to 1000000 by default. 1000000
top

Samples

top

Sample

Sample

{
  "MigrationTools": {
    "Version": "16.0",
    "CommonTools": {
      "StringManipulatorTool": {
        "Enabled": "True",
        "Manipulators": [
          {
            "$type": "RegexStringManipulator",
            "Description": "Remove invalid characters from the end of the string",
            "Enabled": "True",
            "Pattern": "[^( -~)\n\r\t]+",
            "Replacement": ""
          }
        ],
        "MaxStringLength": "1000000"
      }
    }
  }
}
top

Defaults

Defaults

{
  "MigrationTools": {
    "Version": "16.0",
    "CommonTools": {
      "StringManipulatorTool": {
        "Enabled": "True",
        "Manipulators": null,
        "MaxStringLength": "1000000"
      }
    }
  }
}
top

Classic

Classic

{
  "$type": "StringManipulatorToolOptions",
  "Enabled": true,
  "MaxStringLength": 1000000,
  "Manipulators": [
    {
      "Enabled": true,
      "Pattern": "[^( -~)\n\r\t]+",
      "Replacement": "",
      "Description": "Remove invalid characters from the end of the string"
    }
  ]
}
top

Metadata

Project Information
Azure DevOps Marketplace
YouTube Channel
Maintainer

Created and maintained by Martin Hinshelwood of nkdagility.com

Documentation Versions
Production Azure DevOps Migration Tools Release Version
Preview Azure DevOps Migration Tools Preview Version
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