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.