Import a CSV file to Include Date Created and Date Modified

Question

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?

jthi · Accepted Answer

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

SpannerHead · Accepted Answer

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)));