11-27-2006, 12:36 PM
|
#1 |
|
Chief of Naval Operations
  
Join Date: May 2001
Location: City of The Dead
Posts: 13,552
   |
DOS network look-up help
Ugh.
I have an Excel spreadsheet that is about 5k lines. The first column is the only one that matters. The first column is full of job order numbers (ex. 56246, 60078, 74589) I would like to run a little script (as opposed to checking line-by-line) to check the first column against what is in our directory structure. We have directories of 50000, 60000, 70000, 80000 & 90000. I know there are going to be missing ones. I'd like to get a file of all the missing files so I know what I need to really look for/update the spreadsheet. My eyes appreciate any help someone can give me. |
|
|
|
11-27-2006, 01:57 PM
|
#2 |
|
Chief of Naval Operations
Join Date: May 2001
Location: City of The Dead
Posts: 13,552
|
I've copy and pasted the entire 50000 dir from the spread sheet to a txt file with 1 number p/line. Then I did a dir > 50000.txt and cut out all the extra info that I didn't need.
I opened CMD, went to the network drive and tried both COMP ( COMP TEST.TXT 50000.TXT) and FC ( FC TEST.TXT 50000.TXT). Comp told me the file sizes were different (  ), FC runs a little and then tells me they are too different to compare.Just thought I would update. |
|
|
|
|
11-27-2006, 02:47 PM
|
#3 |
|
Chief of Naval Operations
Join Date: Aug 2002
Location: raising my pimp hand strong
Posts: 13,038
|
you could have run a vlookup and just had it return a value of 1 in the column it found data for. and then sorted the cells without a returned number. maybe?
|
|
|
|
|
11-27-2006, 04:51 PM
|
#4 | |
|
Chief of Naval Operations
Join Date: May 2001
Location: City of The Dead
Posts: 13,552
|
Quote:
*searches google for mysterious vlookup* That sounds like it could work. Thanks, I'll let you know if it works. |
|
|
|
|
|
11-28-2006, 12:08 PM
|
#5 | |
|
Chief of Naval Operations
Join Date: May 2001
Location: City of The Dead
Posts: 13,552
|
Quote:
After doing a little searching it sounds like I need to do a combonation of vlookup, IF & ISNA, however I don't understand the damn examples. *grumbles* |
|
|
|
|
|
11-28-2006, 12:15 PM
|
#6 |
|
Chief of Naval Operations
Join Date: Aug 2002
Location: raising my pimp hand strong
Posts: 13,038
|
i can absolutely help with the vlookup. only because i had to fumble through the crappy explainations enough times until i knew what it meant.
pm me for my phone number if you need walked through it. |
|
|
|
|
11-28-2006, 12:33 PM
|
#7 | |
|
President, Cowboys Nation
 
Join Date: Dec 2004
Location: In the 'burbs, west of D.C.
Posts: 5,139
|
Quote:
Bet you use this line on all the ladies Big C. 
__________________
 
|
|
|
|
|
|
11-28-2006, 12:35 PM
|
#8 |
|
Chief of Naval Operations
Join Date: Aug 2002
Location: raising my pimp hand strong
Posts: 13,038
|
 |
|
|
|
Linear Mode
