7 Replies Latest reply: Apr 7, 2016 6:34 PM by Leo Doherty RSS

    'Substitute' question

    Leo Doherty

      Hi!

       

      My first post/question.

       

      I'm loading data from multiple sources, and the ProductId is formatted in different ways.

       

      In most sources its formatted like below (goal):

       

      183552000

      183552001

      183552012

      183552123

       

      But in some sources it looks like below (needs to be formatted):

       

      18-3552

      18-3552-1

      18-3552-12

      18-3552-123


      So first of all I need to get rid of the " - ", but that I can solve with substitute. But what I'm struggling with is how I deal with adding the zeros before the last number(s), making them all the same length.


      Any ideas on how to solve this would be greatly appreciated!