1 Reply Latest reply: Sep 21, 2012 5:43 AM by whiteline _ RSS

    How to Export Table and exclude Field Labels

      Hi All,

       

      I'm trying to store data in a table into a text file, but i'm trying to leave out the labels as I only need the data (which will only ever be one field/row)

       

      My Current code is as follows:

       

      NOCONCATENATE
      EmailSubject:
      LOAD
          LTRIM(MaxString(EmailSubjTmp)) as 'SubjectLine'
      RESIDENT [TMPEmailSubject];
      
      DROP TABLE TMPEmailSubject;
      
      STORE SubjectLine FROM EmailSubject INTO [EmailSubject.txt](txt, codepage is 1252, no labels, delimiter is '\n', no quotes);
      

       

      For some reason, in the STORE line, evey parameter after txt is normal text and not highlighted as usual....codepage for example shows up as an error when i do a syntax check.

       

      My resulting file has in the first line 'SubjectLine' and on the second line is the data. I ONLY want the data.

       

      Any help will be highly apprciated.