AnsweredAssumed Answered

Extracting extension type from container field

Question asked by benbear on Feb 4, 2017
Latest reply on Feb 9, 2017 by beverly

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.

Outcomes