849142_en-US

liliconcom

Import a CSV file to Include Date Created and Date Modified

I need to import a series of CSV files that do not explicitly contain a date stamp as data text.  Am I able to somehow collect the date modified and / or date created to fill in the blanks?

Automation and ScriptingRe: Import a CSV file to Include Date Created and Date Modified

With Multiple File Import you can add file creation date

And if you are opening those using JSL you can use Last Modification Date

and/or Creation Date to add new column after you load the .csv as a table

both are found under File in Script Index and JSL Syntax Reference

Re: Import a CSV file to Include Date Created and Date Modified

I got this to work with this included in an iteration.

 

Current_File = path || final_files[i],
<BR />Creation_Date = Format( Creation Date(Current_file), "ddmonyyyy:h:m:s");
        
Modification_Date = Format( Last Modification Date(Current_file), "ddmonyyyy:h:m:s");

dt << New Column("Creation Date", Character, "Nominal", Formula(Eval(Creation_Date)));
		
dt << New Column("Modification Date", Character, "Nominal", Formula(Eval(Modification_Date)));