cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JPOL
‎09-06-2017
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Concatenating CSV files based on their Last Modification Date

by Calcite | Level 5 in SAS Data Science
‎10-13-2015 05:31 AM
‎10-13-2015 05:31 AM
Thank you all for your suggestions.     A working solution has been provided by MS over in the JMP community.     For those who are interested, I am including it here:       filepath = "K:\....\PROBER_01\";   prefilelist = Files In Directory(filepath);   n2 = N Items(prefilelist);   datelimit = Today() - In Days(30);   filelist = {};   For(i2 = 1, i2 <= n2, i2++,     file = prefilelist[i2];      If(      Word(3, file, "_") == "DRIE" &      Word(2, file, "_") == "ILGO1" &      Substr(file, 5, 1) == "L" &      Substr(file, 1, 1) == "G",      If(Last Modification Date(filepath || file) > datelimit,      Insert Into(filelist, file);      Show(file);      );   );     Best Regards,   Philip         ... View more

Re: Concatenating CSV files based on their Last Modification Date

by Calcite | Level 5 in SAS Data Science
‎10-12-2015 01:09 AM
‎10-12-2015 01:09 AM
Hi reprui,   Here is an example:   Filename                                           Last Modified B35L1007_BK1_FINAL01.csv         10/11/2015 7:23 B36L0216_BK1_GRID25.csv          10/10/2015 22:46 B36L0221_BK1_FINAL25.csv         10/11/2015 4:42 B38L0920_BK1_FINAL25.csv         10/11/2015 18:37 BN30L2515_BO1_FINAL40.csv      10/12/2015 3:31 BN30L2524_BO1_FINAL40.csv      10/12/2015 3:35 BN31L1606_BO1_FINAL01.csv      10/11/2015 10:01 BN31L1625_BO1_FINAL01.csv      10/11/2015 20:48 GK39L0507_GK1_GRID01.csv       10/12/2015 3:59 GK39L0607_GK1_GRID01.csv       10/11/2015 2:30 GN36L0411_ILGO1_DRIE_25.csv 10/11/2015 11:23 GN36L0421_ILGO1_DRIE_25.csv 10/11/2015 11:58 GN38L0319_GO2_FINAL40.csv     10/10/2015 23:48 GN38L0324_GO1_FINAL40.csv     10/10/2015 22:11 GN38L1102_GO2_FINAL25.csv     10/11/2015 15:54 GN38L1120_GO2_FINAL25.csv     10/12/2015 5:55 GN39L0413_GO2_FINAL40.csv     10/12/2015 7:20 GN39L0415_GO2_FINAL40.csv     10/12/2015 7:46 GN39L0418_GO1_FINAL40.csv     10/12/2015 4:22 GN39L0422_GO2_FINAL40.csv     10/12/2015 7:36 GN39L0425_GO1_FINAL40.csv     10/12/2015 4:31 GN39L0525_ILGO1_DRIE_25.csv 10/10/2015 19:51 GP38L0214_GP1_GRID01.csv      10/12/2015 6:29 GP38L0222_GP1_GRID01.csv      10/12/2015 6:39 GP38L0405_GP1_GRID01.csv      10/11/2015 23:17 GP38L0408_GP1_GRID01.csv      10/12/2015 0:36   As you see, it is a combination of incrementally and randomly numbered, based on the LOT IDs and measurement phase.   - Philip ... View more

Re: Concatenating CSV files based on their Last Modification Date

by Calcite | Level 5 in SAS Data Science
‎10-12-2015 12:54 AM
‎10-12-2015 12:54 AM
Yes, this is about file preparation prior to JMP analysis.   - Philip ... View more

Re: Concatenating CSV files based on their Last Modification Date

by Calcite | Level 5 in SAS Data Science
‎10-12-2015 12:52 AM
‎10-12-2015 12:52 AM
Thanks Reeza for your suggestion.   I have copied my question over to the JMP community but I am still open to any suggestions which may come from this community   Rgds,   Philip ... View more

Re: Concatenating CSV files based on their Last Modification Date

by Calcite | Level 5 in SAS Data Science
‎10-09-2015 01:12 PM
‎10-09-2015 01:12 PM
Yes they are. ... View more

Concatenating CSV files based on their Last Modification Date

by Calcite | Level 5 in SAS Data Science
‎10-09-2015 08:29 AM
‎10-09-2015 08:29 AM
Hi,   I am a new JMP12 user and I have a need to concatenate several hundred .CSV files every day in order to monitor a manufacturig tool's performance.   Now that the tool has been in use for several months I currently have ~ 75 000 files on the directory from where I need to read the files. All files need to remain on this directory.   I need to monitor the tool over the last 30 days or so. Opening and concatenating the latest 2000 files would meed my needs.   How can I add to the   filelist   to be opened based on the files' Last Modification Date?   I would like to add an additional time based filter to those already in use:   filepath = "K:\...\PROBER_01\" ; prefilelist = Files In Directory( filepath ); n2=nitems(prefilelist); //Provide filters to ensure appropriate csv files For( i2 = 1, n2 >= i2, i2++, file=(prefilelist[i2]); If ( word( 3, prefilelist[i2], "_" ) == "DRIE" & word( 2, prefilelist[i2], "_" ) == "ILGO1" & substr(prefilelist[i2],5,1 ) == "L" & substr(prefilelist[i2],1,1 ) == "G", Insert Into( filelist,file), show(file) ) );    something like :   & Last Modification Date() > today()-30 days    ??????     Thanks,   Philip ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-06-2017 12:48 AM
Quick links