Using Position and Length

Description

Substitute a number of characters with a different set of characters starting from a set position.

When you apply this operation, you are first asked to set the following:

• The starting position to begin the replace

• The number of characters to replace

• The string to replace with

Use the preview column to help you verify the replace:

 

INPUT/Output DATA TYPE

Input	Output
text	text

 

example

In this example, Operating Name is the original column. We substitute three characters starting from position 1 with the text "ACES OF BASES" to get the values in Operating NameReplace.