2 Replies Latest reply: Apr 21, 2018 12:34 PM by Sasidhar Parupudi RSS

    How to autogenerate Alpha-Numeric string

    Chirayu Chaudhari

      Hi,

      I have a simple problem with a complex solution.

      I have a field called Codes and it is in an alphanumeric format.

      For example. A0000756

       

      Each code has a value associated with it called Value.

       

      For example: A0000756

      Value = 76

       

       

      Now someone has consolidated a range of Codes together.

       

      For example: A0000756-A0000852

       

      I want to split this range in the load editor individually and divide the sum of Value by the count (which is 852-756=96) .

       

      A0000756

      A0000757

      A0000758

      A0000759

      .....

      A0000852

       

       

      Any suggestion will help