Remove Specified Characters

Description

Removes a sequence of characters from the values of the column you apply this operation to.

When you apply this operation, Monarch Data Prep Studio first asks you to enter the sequence of characters you wish to remove.

 

You will also need to specify whether to ignore the case of the characters specified for removal.

INPUT/Output DATA TYPE

Input	Output
text	text

 

example

In this example, Description is the original column. The Remove Specified Characters operation is used to remove commas "," to produce the resulting values in Description - Clean.