Basically the files I have goes like “1.xlsx”, “2.xlsx”…“100.xlsx” etc, but the loop is only going by the first number in the name so it goes 1-10-100 then 2-20 etc. How to make it so it goes in order?
I’m using Directory.GetFiles(directory,“*.xlsx”) to assign the files.
@daqc - Say if the files created in order (one after another)…we can use create time to read it in order…
Directory.GetFiles("YourFolderName","*.xlsx").OrderBy(Function(d) New FileInfo(d).CreationTime).toarray
PLease try and let me know.
Cannot assign from type 'System.Linq.|OrderedEnumerable`1[System.String]'to type ‘System.String’ in Assign activity ‘Assign’.
This method could work with what I have now but also let’s say the files will be named in random regardless of the time created what do i do then? Just for future reference, Thanks.
What is your For each Variable type…it should be string…Please check below…
Let me think on this scenario.
For Each is String in the TypeArgument
Let me think on this scenario
Thank you very much!
Yep that worked, thanks! I’ll try the method on my folder with the 100’s of files. But I’m also curious about the other solutions.
Here you go…
Directory.GetFiles("YourFolderName","*.pdf").OrderBy(Function(d) cint(path.GetFileNameWithoutExtension(d))).toarray
Source: Assign
Message: Conversion from string “test_voice” to type ‘Integer’ is not valid.
Exception Type: System.InvalidCastException
Directory.GetFiles(“YourFolderName”,“*.pdf”).OrderBy(Function(d) cint(path.GetFileNameWithoutExtension(d))).toarray
This one is perfect. I think I’ll use this method. Thanks for the inputs and help!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.