@Al i can't test right now in my system to see if this would work on that particular field, but can you try SUBSTR({payingtransaction.appliedtotransaction}, -8)

that worked! 🙂 just adjusted it to -9