4 Replies Latest reply on Nov 27, 2018 11:11 AM by Deepak Rai

    Select one of the two column values based on characters

    Garrett Dube

      Hi all,

       

      I'm trying to select only one value of two based on a character calculated field. From the picture below, I want to only show the Enumber where 'E' comes after it if it is there, else keep the normal Enumber such as 102. Please let me know if I need to clarify further.

       

      Goal Output:

       

      Bob          July 1, 2018     1     100E     $5

      Corey       July 6, 2018     5     104E     $20

      Dave        July 5, 2018     4     103E     $12

      George    July 2, 2018      2     101E     $6

      Jake        July 1, 2018      3     102       $10

       

      Thanks in advance!