Extract and generate phone number strings

Extract and generate phone number strings is project number 104809 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider indradj
Budget:	$100-300
Created:	11/07/2006 at 0:36 EST
Bidding Ends:	11/14/2006 at 0:36 EST
Project Creator:	brock7613   Buyer Rating: (3 reviews)
Description:	Extract and generate phone number strings I have a two step process that I need accomplished in a program. Probably two seperate programs to accomplish these tasks would be best. 1. Extract phone numbers from a string of data 2. Generate phone numbers based on the criteria given. Program One: I want a program to extract phone numbers from a few different formats. Sample Format One: "Name","Address","City","State","ZIP/Postal","Phone","BusCode","BusOrRes","SolicitFlag","BusType","Last Name","First Name","Middle Initial","Suffix","Secondary Name","URL","Country" "Abaring Josie B","8282 Cambridge St","Houston","TX","77054","713-799-2671","","R","","","Abaring","Josie","B","","","","US" "Abbott April","7200 Almeda Rd","Houston","TX","77054","713-799-9123","","R","","","Abbott","April","","","","","US" "Abendanio Annabelle","8282 Cambridge St","Houston","TX","77054","713-795-4027","","R","N","","Abendanio","Annabelle","","","","","US" "Acholonu Sandra","7900 Cambridge St","Houston","TX","77054","713-799-8088","","R","","","Acholonu","Sandra","","","","","US" "Acosta Jose","8100 Cambridge St","Houston","TX","77054","713-795-5313","","R","N","","Acosta","Jose","","","","","US" "Adam Lianna","7900 Cambridge St","Houston","TX","77054","713-795-0576","","R","","","Adam","Lianna","","","","","US" "Adams Brook","7009 Almeda Rd","Houston","TX","77054","713-550-9058","","R","","","Adams","Brook","","","","","US" "Aguilar D","7900 Cambridge St","Houston","TX","77054","713-791-9480","","R","","","Aguilar","D","","","","","US" "Agyemang Krystal","8282 Cambridge St","Houston","TX","77054","713-795-9552","","R","N","","Agyemang","Krystal","","","","","US" Sample Format Two: 210 2102159661 07/01/2004 210 2102159671 07/01/2005 210 2102159673 01/01/2004 210 2102159680 07/01/2005 210 2102159682 04/01/2006 210 2102159684 10/01/2004 210 2102159687 10/01/2005 210 2102159690 01/01/2006 210 2102159691 01/01/2005 210 2102159697 01/01/2005 210 2102159699 01/01/2004 210 2102159700 01/01/2004 ( I have underlined what I am trying to extract only for demonstration purposes) After extracting the phone numbers from either format, a new text file should be created with only one phone number per line. When opened the new text file with the extracted data should look like this: Example: 713-799-2671 713-799-9123 713-795-4027 713-799-8088 713-795-5313 713-795-0576 713-550-9058 713-791-9480 713-795-9552 The program would need to be able to extract text in excess of 100 MB. Some of the text files to extract from are over 100 MB. This is why I can use excell, and this is why I have problems with other programs. Program Two I need the ability to generate phone numbers based on the data provided (phone numbers provided). But first the list of data needs to be sorted. This program needs to accomplish 3 steps. 1. Sort Data 2. Analyze Data 3. Generate Phone numbers. For example: If I provided the following list of phone numbers: 713-555-1014 214-335-7832 713-999-5501 214-335-6001 713-999-5506 713-999-5512 214-335-6007 214-335-7500 713-555-1000 713-555-1001 713-555-1007 214-335-6003 713-555-1011 214-335-6004 713-999-5509 713-555-1004 214-335-6000 713-999-5507 713-999-5502 214-335-6012 713-999-5518 713-999-5500 214-335-6003 713-555-1002 713-555-1010 The first job of this program is to sort the numbers numerically as follows: 214-335-6000 214-335-6001 214-335-6003 214-335-6004 214-335-6007 214-335-6012 214-335-7500 214-335-7832 713-555-1000 713-555-1001 713-555-1002 713-555-1004 713-555-1007 713-555-1010 713-555-1011 713-555-1014 713-999-5500 713-999-5501 713-999-5502 713-999-5506 713-999-5507 713-999-5509 713-999-5512 713-999-5518 The next step is for the program to give the user information about the list, so the user can make some choices. I would like to draw your attention that the purpose of this program is to generate phone numbers based on the gaps in the list provided. However the program must only generate specific numbers based on area code, the prefix, and the final four numbers...if not the list will be un reliable. The program should recognize gaps greater than 50 (This number should be allowed to be changable by the user to any number desired). If a gap is greater than 50 then it goes to the next sequence to be generated. For example: THe program should recognize that there are 2 different area codes: 214, and 713. The program should recognize how many sperate prefixes there are: 214-335 for 713 713-555 713-999 We are only dealing with generating numbers in existing prefixes. The program should give the user (based on the list and settings provided) the approx ammount of numbers to be generated, and allow the user to decide to adjust the "ingore if greater than" number. It should also list the prefixes to be generated, and allow the user to to delete unwanted prefixes. It should also list the anything numbers or prefixes that will be ignored in the list because of the ignore function, and give the user an oppertunity to allow it. Sumary: Give the user: Approx outcome based on the criteria the Prefixes and numbers to be generated (ex: 214-335-6000 to 214-335-6013) The current "ignore if greater than" feature and ask user if he wants to adjust it to get a smaller or larger outcome allow user to delete unwanted prefixes List numbers and prefixes that will be ignored. Then the user can generate the list The process: Then the program should recognize the gaps to be filled in based on the liste above. 214-335-6002 214-335-6005 214-335-6006 213-335-6008 214-335-6009 213-335-6010 214-335-6011 213-335-6013 The program should now recognize a gap greater than 50. The next number in chronoligical order is 214-335-7500 however there are no surrounding number that is less than 50 (7451 to 7549) so the number is ignored. The same thing is true with the next number 214-335-7832, so it is ignored. Next in the list: 713-555-1003 713-555-1005 713-555-1006 713-555-1004 713-555-1008 713-555-1009 713-555-1012 713-555-1013 the program would then recognize again that there are no other numbers with in 50 so it finds the next sequence. 713-999-5503 713-999-5504 713-999-5505 713-999-5508 713-999-5510 713-999-5511 713-999-5513 713-999-5514 713-999-5515 713-999-5516 713-999-5517 The program would also need a feature to ask the user to include all numbers in the final list, or just numbers generated. (original list and generated list, or just generated list.)
Job Type:
Database:	(I don't know)
Operating system:	MS Windows
Bid count:	30
Average bid:	$ 153