11 Replies Latest reply: Dec 17, 2015 6:51 PM by Marco Wedel RSS

    LOOP THROUGH FILES IN FOLDER AND REMOVE CHARACTERS FROM FIELD NAMES AND DATA

    Chris Hopkins

      Hi All,

       

      i need some help with getting some files stored to QVD but removing some characters from the data and field names.

      there are over 500 files in total, i can do it manually but it will be very time consuming as each file has different field names ( i can't get * to work).

      basically the field names are in the format of

      @@FIELD1@@

      @@FIELD2@@

      @@FIELD3@@

      etc

       

      and the data held against each field is in the same format, i.e...

       

      @@FIELD1@@

      @@VALUE1@@

      @@VALUE2@@

      @@VALUE3@@

      etc

       

      also, the last field in in each file has a SPACE before the last 2@@ i.e.

       

      [@@FIELD40@@ ]

      the space also needs to be removed.

       

      I have attached an example, can anyone help please?