6 Replies Latest reply: Aug 2, 2011 1:10 PM by Mayank Rishu RSS

    Remove() function in filters

      Hi,

      I am going through a script which loads data from .csv file. Script contains "Remove()" function in the filters and I an unable to comprehend the usage and syntax. Can somebody help me on this?

       

      Code Extract:

      Load

      .....

      .....

      FROM

      O1.csv

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq, filters(

      Remove(Col, Pos(Top, 2)),

      Remove(Col, Pos(Top, 4)),

      Remove(Col, Pos(Top, 36))

      ));

       

       

      Thanks a lot!

       

      rishu