I was hoping some of the more experienced Alteryx users could help me out with how to go about separating the last two digits/characters from what we would call a product code from our database list. An example would be product code J2102HG05. Usually the last two digits/characters, in this case 05, has a unique meaning to us which we are looking to identify for some upcoming projects. I would like to split the original product code such as J2102HG05 to two columns, one being the main stem of the code such J2102HG and the other column being 05. I think my answer would be using the parse method from the Regex tool but I am stuck on developing the expression.
