1 2 Previous Next 26 Replies Latest reply on Feb 9, 2017 3:27 AM by beverly

    Extracting extension type from container field

    benbear

      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.

        1 2 Previous Next