Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi.
You can try to use macro to export whan you want.