4 Replies Latest reply on Apr 29, 2013 9:09 AM by philmodjunk

    replace a numberd list with letters

    FrancescoCerofolini

      Title

      replace a numberd list with letters

      Post

           hello everybody,

           my problem is the following:

           i have records with numbered index fields like:

           Record: 1 Index:  10
           Record: 2 Index:  20 
           Record: 3 Index:  25 
           Record: 4 Index:  27
           Record: 5 Index:  30

           and i need them replaced with the value of a valuelist like:

           a,b,c,d,e

           respecting the sort order of the numberd index field. 

           Basicaly my output should be

            

           Record: 1 Index:  10 CalculatedValue: a
           Record: 2 Index:  20  CalculatedValue: b
           Record: 3 Index:  25  CalculatedValue: c
           Record: 4 Index:  27 CalculatedValue: d
           Record: 5 Index:  30 CalculatedValue: e

      is there some function to help me?
           To make it harder i can add that the index field can repeat across my table, as it is actually a SubIndex based on another Index. The Final Output should be something like:
            

                Record: 1   Index: 1 SubIndex:  10 CalculatedValue: a
                Record: 2   Index: 1 SubIndex:  20 CalculatedValue: b
                Record: 3   Index: 1 SubIndex:  25 CalculatedValue: c
                Record: 4   Index: 1 SubIndex:  27 CalculatedValue: d
                Record: 5   Index: 1 SubIndex:  30 CalculatedValue: e
                Record: 6   Index: 2 SubIndex:  10 CalculatedValue: a
                Record: 7   Index: 2 SubIndex:  21 CalculatedValue: b
                Record: 8   Index: 2 SubIndex:  25 CalculatedValue: c
                Record: 9   Index: 2 SubIndex:  30 CalculatedValue: d
                Record: 10 Index: 2 SubIndex:  40 CalculatedValue: e

      THANKS A LOT FOR HELPING!!!!!
            
           if i wasn't clear just asks, as it's really hard to explain.
           thanks a lot!
           Cisco