I made three calculated fields that would seem to solve your issue. However, it is generally not good practice to parse variable length keys. If you need a make a key in that fashion, lead the values with 0's in order to fix the length, this makes parsing IMMENSELY easier. However, these fields should help you at the cost of significant CPU resources.
These fields are called "Left", "Mid", and "Right" in the attached workbook.
Hope this helps,
Book2.twbx.zip 29.5 KB
Thank you Brad. Let me check this out. I will let you know if it works!