At 05:56 PM 7/10/2012, mike epstein sony viao office wrote:
I know that I have done this before but can remember how I did it.
SET VAR vfnam TEXT = 'MORDER'
CHOOSE vfdate FROM #VALUES FOR DISTINCT pdate FROM mordrs WHERE
pdate > (.#DATE-12)
SET VAR vfdate1 DATE = .vfdate
SET VAR vfdate TEXT =(SSTRIPI(.vfdate,'/'))
SET VAR vfnmndt TEXT = (.vfnam+.vfdate+ '.CSV') this is file
'morder07012012.csv'
I am trying to export a csv file from a table using gateway. I was
able to create
the filename (above)
But can't get the filename of the variable ( .vfnmndt)
To list as f:\rbti\nrbfiles\'morder07012012.csv
GATEWAY EXPORT csv .VFNMDT +
SELECT QTY PARTID FROM MORDRS WHERE PDATE =.VFDATE1 +
OPTION COL_NAMES OFF +
|HEADER_TEXT SOURCE '.VFNMNDT' +
|SHOW_PROGRESS ON +
|ACTION OPENVIEW
SET TRACE OFF
RETURN
Mike,
Here's how to create a dynamic file name based upon given variables:
-- Example 01
SET VAR vFileName TEXT = NULL
SET VAR vFileName = (.vFNam+(FORMAT(.vFDate,'MMDDYYYY'))+'.CSV')
-- Example 02
SET VAR vFileNameWithPath TEXT = NULL
SET VAR vFileNameWithPath =
('F:\RBTI\NRBFiles\'+.vFNam+(FORMAT(.vFDate,'MMDDYYYY'))+'.CSV')
That's all there is to it!
Very Best R:egards,
Razzak.
