Monarch Data Prep Functions | Replace - Using Position & Length


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.