rcmurphy@mac.com

Scheduled import with dynamic timestamp

Discussion created by rcmurphy@mac.com on Oct 8, 2016
Latest reply on Oct 14, 2016 by philmodjunk

Hi, I'm hoping there is a simple answer to this question. I have a scheduled script running nightly that imports records from a file.

 

The filenames are standardized with "Import" then date: Import_20161008

 

Current script step for the filepath is:

Set Variable [ $filePath ; Value:"filewin:" & $LandingZone & $region & "Import_" & Year ( Get(CurrentDate) ) & Right ( "00" & Month ( Get ( CurrentDate ) ) ; 2 ) & Right("00" & Day ( Get ( CurrentDate ) ) ; 2) & ".csv"

 

The new filenames are going to include a timestamp, rather than just the date: Import_20161008_1463.csv

 

My question is: )other than manually removing the 4 numbers that represent the time) how do I account for the (dynamic) time in the filepath?

 

 

Outcomes