I have a formula to calculate a unique transaction sequence number that works as follows:
transaction sequence(TS) * 100 + record sequence(RS)
So take two examples: 118(TS) * 100 + 103(RS) = 11903 99(TS) * 100 + 50 = 9950
From the results I need to be able to get back to determine the original TS and RS. The solution has to work for both examples above. So in the case of 11903 I need to get back to 118 and 103 and in the case of 9950 I need to get to 99 and 50.