naming of output files:

[Jay Dutta]

Hi: I am trying to save the data into an excel file but i would like to name the excel as
FileName_[yyyy]_[mm-1].xls

month has to be previous month number and not current month; can this be done in the xprj file output naming section? or some other way?

please assist; i do not (yet) want to write a vbscript or other program to rename it.

thanks a bunch in advance,
Jay

[Todd Niemi]

Jay, you can do this by specifying the following in the "Save As" field on the Export Wizard's File Info screen:

Filename_&[yyyy]_&[mm.-1m].xls

For example, specifying the following in the Save As field would export an Excel file named "Export1_2006_01.xls" to the Data Pump Exports folder:

C:Program FilesMonarch Data PumpExportsExport1_&[yyyy]_&[mm.-1m].xls

[ February 24, 2006, 02:36 PM: Message edited by: Todd Niemi ]

[Gareth Horton]

Jay,

Todd has jumped the gun somewhat, as the functionality to which he is referring in not available in the current release of MDP.

It will be available in MDP 8.5, free to those on maintenance.

The new functionality is using Date Offsets with macros, which Todd has given you the syntax for.


Gareth

Originally posted by JAY DUTTA:
Hi: I am trying to save the data into an excel file but i would like to name the excel as
FileName_[yyyy]_[mm-1].xls

month has to be previous month number and not current month; can this be done in the xprj file output naming section? or some other way?

please assist; i do not (yet) want to write a vbscript or other program to rename it.

thanks a bunch in advance,
Jay

[Todd Niemi]

Sorry about that, guys. Hope you can wait a few days (or weeks?) for the date offset functionality, Jay.