Using Position and Length
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
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.