This project has moved. For the latest updates, please go here.

Regex find and replace

Summary

This transform allows you to apply a regular expression find-and-replace operation to an incoming string value

Parameters

Parameter Description
Find pattern Specifies the regular expression pattern used to match the string in the incoming value
Replace pattern Specifies the substitution pattern to insert into the string where values matched the find pattern

Input Type

The transform accepts string values as an input.

Multiple input values

The transform accepts multiple input values, and processes each of them individually.

Return Type

The transform returns a string value.

Usage

Input value Find Pattern Replace Pattern Description Output value
Lithnet ACMA ([^\s]+).*$ $1 Finds the first word Lithnet
ABC123DEF [^a-zA-Z] Remove non-alpha characters ABCDEF
000123 ^0+ Remove leading zeros 123

Last edited Feb 22, 2015 at 2:05 AM by ryannewington, version 1