6 Replies Latest reply: Feb 25, 2013 12:52 AM by Kalyana Sundaram RSS

    Grouping

    Kalyana Sundaram

      Hi all,

       

      please help me to solve this one

       

      i have a account code field

      100000000

      200000000

      300000000

      400000000

      500000000

      1211

      1212

      ........

      ,,,,,,,,,

      2211

      2213

      ..............

      ..............

      ..........

      3213

      3212

      ...........

      ..............

      4211

      4212

      ............

      ..............

      521

      5211

       

       

      the field in which the first five long values should be account header, so i need those five values to brought out in the another field, so that if we put straight table we can have more description, fisrt account header, next respective account no. to account header and categories

      is there any way to do this in script to seperate first five and relate those values  with respective account nos

       

      please help me