I am trying to extract only the extension type only from a container reference field. I have successfully extracted other information though, this one has me stumped I have tried various iterations of RIGHT, MIDDLE etc and searching for the "." however, due to the fact that the reference has for example c://.. it is picking up these as just a ".". I guess what i am looking for is working from the right get each character until the first "." So how does one define that in a calc. Thanks.