Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

NAME VALIDATION SOFTWARE

Posted on 2006-06-23
11
217 Views
Last Modified: 2010-04-25
I am working on a project where i have to check name is correct or not its very big file like 35000 record. i have to go one by one to check name is correct or not. is there any software where i upload my name and its give me a not a valid name list.

thanks
0
Comment
Question by:LINGSAEED
  • 6
  • 5
11 Comments
 
LVL 69

Expert Comment

by:Callandor
ID: 16969832
If there aren't too many other columns, you could use Excel to do a lookup once the 35000 names are in.
0
 

Author Comment

by:LINGSAEED
ID: 16969905
what you mean by lookup in excel . it will tell me its correct person name .
0
 
LVL 69

Expert Comment

by:Callandor
ID: 16969988
Excel lets you look up a value in an array:
=VLOOKUP(testvalue, range_of_names, offset, FALSE)

testvalue is the name you want to test
range_of_names is the list of names to check against
offset is 1 if all you want is the name
FALSE will force it to display #N/A if it doesn't find it, otherwise, it will display the name
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:LINGSAEED
ID: 16970067
can you explain me how i will do it in excel step by step . i have a name 35000 i want to check the name is correct or not .

thanks
0
 
LVL 69

Expert Comment

by:Callandor
ID: 16970196
Import all the names into Excel - let's say you put them in range A1..A35000.  Use Excel to sort them alphabetically if they are not sorted, using Data->Sort.

In cell B1, put the name you want to test against the records.
In cell C1, put in the formula =VLOOKUP(B1,A$1..A$35000,1, FALSE)
C1 will display the name if it finds it; otherwise, it will display #N/A

You can do this for each name you have to test by copying cells B1 and C1.
0
 

Author Comment

by:LINGSAEED
ID: 16970252
You are try to tell me i have to have a correct name list in colum B . Where i will get correct name . i am getting a excell with name that is not correct and i have to go each record and check its correct name or not.

thanks
0
 
LVL 69

Expert Comment

by:Callandor
ID: 16970298
Well, how are you going to know if a name is spelled correctly?  A computer has to look this up somewhere, and that means you or some other source.
0
 

Author Comment

by:LINGSAEED
ID: 16970356
what my question is there any software where i  can test against that database.

thanks
0
 
LVL 69

Expert Comment

by:Callandor
ID: 16970497
Ok, so you want a name database to compare against?  That will be very difficult, because names can be spelled differently and still be correct.  Some people have names that are deliberately different than common spelling.  How are you doing this manually, and how do you know if the spelling is right?
0
 

Author Comment

by:LINGSAEED
ID: 16970553
Thats a problem if i can narrow the error .
so i have to have a correct name list. then i will check my name against that list.
thanks
0
 
LVL 69

Accepted Solution

by:
Callandor earned 250 total points
ID: 16970756
If you don't have an existing list, you'll have to buy one.  For example: http://www.cms-summit.com/SoftwareSolutions/NameAddVal.htm
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Many people don't really know what the difference is between memory and storage. And most regular users don't understand the relationship between any of those fancy words printed on the front of their new computer. Of course, it's perfectly fine -- …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question