Darth Yoda Posted October 15, 2011 Member ID: 934 Group: **- Inactive Registered Users Followers: 19 Topic Count: 131 Topics Per Day: 0.02 Content Count: 832 Content Per Day: 0.15 Reputation: 137 Achievement Points: 5656 Solved Content: 0 Days Won: 0 Joined: 12/27/09 Status: Offline Last Seen: November 19, 2014 Birthday: 08/16/1960 Posted October 15, 2011 Not really a computer problem as much as software. I need a program that will sort a bunch of files by left string preferably with a browse button to select the correct folder. Example: When windows sorts files they are alpha-numerically sorted. Like this: 1 6 19 23 136 192 400 1468 1000005 here you have first digit 1's list top middle and bottom I need to sort them like this (using the left most character then the next left most): 1 there is no second character so it gets listed 1000005 the first 0 is lower the 3 in 136 so it gets listed next 136 3 is lower than 4 in 1462 by comparing the second digit. 1468 192 23 400 6 so if you look at the fist character on the far left and read DOWN you see all the 1's listed the 2's, 3's. 4's etc. Then the second numbers read lowest to highest reading down. If you look in a bearing catalog you can really see how efficient it is as opposed to traditional listing. It also has to be alpha numeric with letters first as I have thousands of part numbers in various formats. I f you know of a program let me know. Or some of you smarter fellas could try to program it!?!?!?!?!? Anyway thanks in advance for you time and input. See you on the killing field. As a side note I won lunch today at work. One of my co-workers was renaming the same thousands of files by adding a letter to the front of it. Like this B1468 it was 1468. I bet him I could have it done by lunch (about two hours). He agreed to the bet. I downloaded Rename4U ran it on a couple of folders and viola! Three days work done in 27 minutes.
Labob Posted October 15, 2011 Member ID: 42 Group: *** Clan Members Followers: 50 Topic Count: 338 Topics Per Day: 0.06 Content Count: 8389 Content Per Day: 1.45 Reputation: 6126 Achievement Points: 54469 Solved Content: 0 Days Won: 13 Joined: 09/01/09 Status: Offline Last Seen: Wednesday at 07:30 PM Birthday: 01/30/1959 Device: Windows Posted October 15, 2011 I don't know but the really wierd guys are sent to the bench maked w Awards
Masterlixx Posted October 15, 2011 Member ID: 285 Group: ***- Inactive Clan Members Followers: 3 Topic Count: 69 Topics Per Day: 0.01 Content Count: 290 Content Per Day: 0.05 Reputation: 20 Achievement Points: 2204 Solved Content: 0 Days Won: 0 Joined: 09/06/09 Status: Offline Last Seen: April 7 Birthday: 11/04/1965 Device: Windows Posted October 15, 2011 Here is an easy way.. if you have excell open the cmd windows.. goto run and type cmd to get you to dos chagne to the directory where the files are listed type dir > somefilename.txt go into excell and open somefilename.txt You will have to create a helpr key for the sort so your vaues will be in column a, in column b type =TEXT(A1, “###”) in your line 1 column b cell then copy that formula all the way down then sort by the columnb, and xcell will ask you to "sort numbers and numbers stored as text seperatly" and then the follwoing will happend 1 2 3 4 12a 1a will be come 1 12a 1a 2 3 4 Awards
Darth Yoda Posted October 16, 2011 Member ID: 934 Group: **- Inactive Registered Users Followers: 19 Topic Count: 131 Topics Per Day: 0.02 Content Count: 832 Content Per Day: 0.15 Reputation: 137 Achievement Points: 5656 Solved Content: 0 Days Won: 0 Joined: 12/27/09 Status: Offline Last Seen: November 19, 2014 Birthday: 08/16/1960 Author Posted October 16, 2011 Thanks for the info Lixx. Will try it Monday at work and get back to you.
Recommended Posts