HomeForum
Welcome, Guest

Rename Files
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Rename Files

Rename Files 1 year, 3 months ago #1562

  • Star
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
I need to name an export file with the convention of YYYYMMDD_hhmmss.txt
I have been trying GetSystemDate(YYYYMMDD) and GetSystemDate(hhmmss) which individually work great but I cannot get both to execute.
Can I use 2 functions in the export filename mask????
how??
syntax??

Steve

Re: Rename Files 1 year, 3 months ago #1563

  • admin
  • NOW ONLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Something like this should do
{GetSystemDate(YYYYMMDD) +'_'+GetSystemDate(hhmmss) }.txt

Mike

Re: Rename Files 1 year, 3 months ago #1564

  • Star
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
that just gives me the filename {GetSystemDate(YYYYMMDD) +'_'+GetSystemDate(hhmmss)}.txt

Re: Rename Files 1 year, 3 months ago #1565

  • admin
  • NOW ONLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
This one did work

C:\Program Files\DB Software Laboratory\Demo\Buffer\{GetSystemDate('YYYYMMDD') +'_'+GetSystemDate('hhmmss')}.txt.csv

Mike
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

"This [Visual Importer ETL] is such a great help. As expected, it has paid for itself within one week!"

Phill Stive,
Oracle DBA, OU,
Newcaste

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top