Hello all,
I have some unfortunate file names that are giving me trouble. I need to import all the pictures from a folder I have. They are saved in the order that I want and all within 1 second.
The issue is that when I import them using the directory tool, it puts them slightly out of order based on number:
So I need it to import them in order (ex. 1.1, 1.2, 1.3) not 1.1, 1.10, 1.11, 1.2. They are all saved within the same second so I cant just sort by CreationTime descending.
Any thoughts?
Solved! Go to Solution.
You should be able to parse out the numbers into a new column and then sort based on that column. If you have a sample file name we can help figure out the best formula.
It was even simpler! Thank you, your idea led me to the solution.
What I had to do what Sort tool and then sort by filename ascending and check the "Use Dictionary Order" box.
This allowed it to sort 1, 2, 3 and not 1, 10, 11, 2, 3, etc.
Thank you!