- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to make JSL get file timestamp?
Anyone know of any code say utilizing the JSL DLL features to get a file's date/timestamp? For example, get the timestamp for: "C:\mytest.jmp". thx... dj
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to make JSL get file timestamp?
I don't know if it's a solution for you but I propose the following jsl :
strPathFile = "C:\mytest.jmp";
//Save batch file to get date file : create DateFile.txt containing date
Save Text File(
"C:\GetDate.bat",
"for %%x in ("||strPathFile||") do echo datetime=%%~tx >> C:\DateFile.txt";
);
//Launch batch file
Open("C:\GetDate.bat");
wait(1);//wait to let time running batch file
//Open DateFile.txt containing date file in a jmp data table
Open("C:\DateFile.txt",
columns( c000001 = Character ),
Import Settings(
End Of Line( CRLF, CR, LF ),
End Of Field( Comma ),
Strip Quotes( 1 ),
Use Apostrophe as Quotation Mark( 0 ),
Scan Whole File( 1 ),
Treat empty columns as numeric( 0 ),
Labels( 0 ),
Column Names Start( 1 ),
Data Starts( 1 ),
Lines To Read( All ),
Year Rule( "10-90" )
)
);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to make JSL get file timestamp?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to make JSL get file timestamp?
If anyone landed here like I did, looking for the other file timestamp, I was able to get it with a related function:
timestamp = Last Modification Date( filePath );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to make JSL get file timestamp?
I don't know if it's a solution for you but I propose the following jsl :
strPathFile = "C:\mytest.jmp";
//Save batch file to get date file : create DateFile.txt containing date
Save Text File(
"C:\GetDate.bat",
"for %%x in ("||strPathFile||") do echo datetime=%%~tx >> C:\DateFile.txt";
);
//Launch batch file
Open("C:\GetDate.bat");
wait(1);//wait to let time running batch file
//Open DateFile.txt containing date file in a jmp data table
Open("C:\DateFile.txt",
columns( c000001 = Character ),
Import Settings(
End Of Line( CRLF, CR, LF ),
End Of Field( Comma ),
Strip Quotes( 1 ),
Use Apostrophe as Quotation Mark( 0 ),
Scan Whole File( 1 ),
Treat empty columns as numeric( 0 ),
Labels( 0 ),
Column Names Start( 1 ),
Data Starts( 1 ),
Lines To Read( All ),
Year Rule( "10-90" )
)
);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to make JSL get file timestamp?
Excellent! That seems to do the trick:). Thanks Carole!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to make JSL get file timestamp?
Check this out:
timestamp = Creation Date( filePath );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to make JSL get file timestamp?
If anyone landed here like I did, looking for the other file timestamp, I was able to get it with a related function:
timestamp = Last Modification Date( filePath );