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:


          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.