Monarch Data Prep Functions | Replace - Using Position & Length

Description:

If you have data like the codes in this column and you want to replace a certain portion of all the codes, you can use Replace Using Position and Length.


Supposing we want to replace the dash and the digit after it, we put in 3 for the start position, 2 for the length, and 00, for example, as the replace string.


Check this box to create a new column, and here are our results.

Comments