3 Replies Latest reply on Nov 9, 2009 3:24 PM by 657263

    help script for conditional skip

    Diego_P
      Hi all,

      I am having problems to set up a script to skip lines from an import file containing total accounts.

      My file format only contains 2 columns Acct and value.
      The trigger to identify the total lines that should be ignored is given by the account length:
      if account length record n < account length record n+1 , then skip, else keep.

      here an example:
      Account: Value: | Acct length: | Commets
      11 $800 | 2<3? | is total, should be ignored
      111 $300 | 3<4? | is total, should be ignored
      1111 $100 | 4<4? | is base, should be read
      1112 $200 | 4<3? | is base, should be read
      112 $500 | 3<...? | is base, should be read
      12
      ...

      Any help on how to write a script linking record n to n+1?

      thanks!!

      Edited by: Diego_P on Nov 1, 2009 11:22 AM

      Edited by: Diego_P on Nov 1, 2009 11:24 AM