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

Import a CSV file to Include Date Created and Date Modified

SpannerHead — Fri, 21 Mar 2025 19:43:42 GMT

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?

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

jthi — Fri, 21 Mar 2025 19:48:35 GMT

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

SpannerHead — Wed, 26 Mar 2025 14:25:46 GMT

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

Current_File = path || final_files[i],

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