Compute and Merge columns in array

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • whitearrow38
    New Member
    • Jul 2010
    • 2

    Compute and Merge columns in array

    Hello
    Here is my issue

    I have a two dimensions array that looks like this:

    EMPTY, Type1, Type2, Type3, Type4
    Choice1, Value11, Value 12, Value 13, Value 14
    Choice2, Value21, Value 22, Value 23, Value 24
    Choice3, Value31, Value 32, Value 33, Value 34

    I am being posted a value from another page which looks like this

    dim mergeAndCompute :mergeAndComput e="ColumnName:T ype1,Type3"

    I've to produce the following array

    AMPTY, ColumnName, Type2, Type4
    Choix1, Value11+Value13 , Value 12, Value 14
    Choix2, Value21+Value23 , Value 22, Value 24
    Choix3, Value31+Value33 , Value 32, Value 34

    I'm lost. I've tried several approches but I can complete the code and that is the reason why I'm requiring your help

    Thx a lot!
    Regards
    WhiteArrow
  • Guido Geurs
    Recognized Expert Contributor
    • Oct 2009
    • 767

    #2
    Is this VB6 or VBA ?

    dim mergeAndCompute :mergeAndComput e="ColumnName:T ype1,Type3"

    Normaly in VB6 it's=

    Array2.ColumnNa me = Array1.Type1 & array1.Type3

    Comment

    • whitearrow38
      New Member
      • Jul 2010
      • 2

      #3
      Infact it is vbscript for asp...

      Comment

      Working...