Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

How can I remove 2300 12 Digit Unique Numbers from a file ...

Sent to Computer Experts January 26 09:19 PM

How can I remove 2300 12 Digit Unique Numbers from a file of 3,000,000 12 Digit Unique Numbers?

Optional Information:
OS: Windows XP; Browser: IE

Already Tried:
Nothing

Customer (name blocked for privacy)
Status:  Closed   Value: $8
Answer
January 27 12:20 PM (15 hours and 1 minute and 9 seconds later)
         
ACCEPTEDCheck Mark
What file are the numbers in? Are they in a text file of spreadsheet such as Excel or Quattro?
Wes Browning -- Information Systems Manager -- No feedback on 3 Computer accepts
MCSE, CCNA
Reply
January 27 6:32 PM (6 hours and 12 minutes and 27 seconds later)
         
They are in a text file.
Customer (name blocked for privacy)
Reply
January 27 6:37 PM (4 minutes and 19 seconds later)
         
Relist: No answer yet.
Customer (name blocked for privacy)
Info Request
January 27 6:54 PM (17 minutes and 19 seconds later)
         
How big is the text file, and what is the criteria for identifying these 2300 numbers - in other words how do you know which numbers are to be deleted?
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2191 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Reply
January 27 7:52 PM (58 minutes and 15 seconds later)
         
We have selected 2300 Alpha Numeric Numbers in advance & we now need to remove them from the entire universe insuring that these numbers do not appear again in the balance of the file after we have removed the 2300.

We are in the contest admin business, and we have not had such a huge list of winning numbers in the past. Need your help. Perhaps we can collaorate in the future.
Customer (name blocked for privacy)
Reply
January 28 9:49 PM (1 day and 1 hour later)
         
Relist:
I never got an answer, justa question. Why did I pay$8.00 to get a question rather than an answer. How do I get my money back.
Customer (name blocked for privacy)
Answer
January 29 9:23 AM (11 hours and 33 minutes and 31 seconds later)
         
ACCEPTEDCheck Mark
The best way I can recommend is to import the master list into Excel. I believe I've recreated a similar example on my system to your problem. Once in Excel I had three sheets: The master list, the list to be removed, and a blank sheet. I wrote a macro to work its way down the master list comparing each cell to all the numbers in the "list to be removed" sheet. If there was no match it would copy the cell to the blank sheet then move down a row and repeat until it reached the end of the master list. The result is a third sheet in Excel (started as the blank sheet) with the original master list minus the "to be removed" numbers. This last sheet can be exported back to a text file type matching the original.

Let me know what you think? If you have Excel and are interested I could send the file over with the macro.

Also, I am sorry for the delay as I was out of town Friday through Saturday.

Thanks again... Wes
Wes Browning -- Information Systems Manager -- No feedback on 3 Computer accepts
MCSE, CCNA
Reply
January 29 11:03 AM (1 hour and 40 minutes and 43 seconds later)
         
Thanks Wes,
I would appreciate you sending me the file.
Customer (name blocked for privacy)
Answer
January 29 4:36 PM (5 hours and 33 minutes and 9 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Wes Browning -- Information Systems Manager -- No feedback on 3 Computer accepts
MCSE, CCNA
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the JustAnswer service comes from those individuals, not from JustAnswer, and that JustAnswer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on JustAnswer are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. JustAnswer is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

JustAnswer > Computer and Software Help