Renaming Files with datetime stamp

srirams

• November 18, 2013 00:00

• Answered

Follow

hi,

I wish to move files from one directory to another directory and rename it by appending datetime stamp using clover ETL. I am using windows 8.

If you know how to do in clover, please share with me.

Thanks
Sriram

• 

  imriskal

  • November 20, 2013 10:43

  0

  Comment actions Permalink

  Dear Sriram,
  
  Moving files can be done with MoveFiles component in jobflow. Directory can be named dynamically using parameter, e.g. ${TIMESTAMP} with value `today()` (as a whole, even with the backquotes) This syntax allow you to use CTL1 functions in parameter values.
  
  If you have any further questions, please let me know.
  
  Kind regards,
• 

  kwrosenzweig

  • November 13, 2015 02:05

  0

  Comment actions Permalink

  How do you add the time stamp to the file name, not the directory?
• 

  Lukas Cholasta

  • November 18, 2015 15:24

  0

  Comment actions Permalink

  Hi
  
  You can add the timestamp to the file name using dynamic parameter, which can hold values dynamically created by CTL2 language. You can use the CTL2 function called today() to get the date and time. However while you want to use it as a part of the file URL, you need to use yet another function called date2str(date, string) in order to get rid of the forbidden characters (space, colons). Please see the attached jobflow and especially the TIMESTAMP parameter, to see how it works.
  
  Please, keep in mind that if you want to use the File Operations components, you need to own a jobflow license. And if you have any further questions, please let me know.
  
  Hope this helps.

  • timestamped_copyfiles.jbf

Please sign in to leave a comment.