4 Replies Latest reply on Feb 26, 2016 6:42 AM by Shinichiro Murakami

    Max Version

    gary.phillips

      Hi, I have a long list of versions by product:

       

      Example:

      v4.0.0

      v5.0.1

      v5.0.2a

      v4.0.0c

      v4.0.14

      v4.0.14a

       

      Is it possible to convert this so it looks like the following:

      (a-z would be converted to a number 1=a 2=b 3=c etc)

       

      400

      501

      5021

      4003

      4014

      40141

       

      The reason why I want to do this is so I can easily max the version per product. Tableau is really struggling to max the version because of the letters and numbers I suspect.

       

      Many thanks