Hi All, I think I have an easy one and multiple ways to go about it but I just can't get it to work as I'm used to character formats and I'm trying to do this with a numeric. Datahave 123456789 Datawant 896712345 Last two become the first two, second to last 2 become the 2nd 2 and finally first 5 become last 5.
... View more