In Progress

letter numbers to digit numbers (sql db)

1. I can give you the problem and maybe you can give me your solution

2. But this is what i need in general

=================================

1. i have a db that has over 800,000 tables , One field on the table is called (Text) which is user posted text of their profile.

2. Each users profile information is saved on this table, including their phone number and details.

Problem: the phone number on these fields are sometimes letters and numbers, spacing, characters, etc.. mixed with other details so it's hard to separate a phone number, and just general details.

example: 7*6*0 5*3*8 3*5*7*6

example: .6198555538

example: 619(206)8one45

example: 858 88zero (7399)

Solution 1: Is to create a new field on the database table called phone number.

Solution 2: Create a program, (linux, php) based that will search each table on the db field (text) and save a phone number in this detail. Being able to translate the letter numbers into digits, even with special characters around it

7*6*0 5*3*8 3*5*7*6 > 760-538-3576

6198555538 > 619-855-5538

619(206)8one45 > 619-206-8145

858 88zero (7399) > 858-880-7399

3. I attached a small version of our db in (zip format) to give you an idea of what the structure is like. You will be working on 2 tables total

4. Were running Centos OS, with apache

Skills: AJAX, Algorithm, HTML, Javascript, PHP

See more: 6198555538, 619 855 5538, 760 538 3576, digit letter phone number sql, 858 880 7399, n numbers, letter format, letter example, example of number problem with solution, example of letter, example of a letter, example letter, detail phone number, 619 206 8one45, 619 206 8145, translate letters, sql based, s+db, LETTER S, letter c, db, apache javascript, javascript phone format, sql maybe, numbers database

About the Employer:
( 68 reviews ) Bucharest, United States

Project ID: #1245981

Awarded to:

jonesa01

Experienced PHP & SQL Developer. Pretty simple project can have up and running within an hour. Please check your PM for more info.

$35 USD in 0 days
(8 Reviews)
3.7

14 freelancers are bidding on average $76 for this job

mkinternation

Hi there, Please check your PM for live demo. I already have most of it done for you. Thanks, Mike

$80 USD in 2 days
(84 Reviews)
6.2
brendonf

Hi. I'll start on this immediately and will deliver the cleaned db's back to you within the next hour or two. Please see PM.

$30 USD in 0 days
(37 Reviews)
4.9
triadb

Hi, please check PM

$45 USD in 3 days
(16 Reviews)
4.5
prasy8

Hi, please check p.m Thanks!

$50 USD in 5 days
(8 Reviews)
4.3
mihaigociu

Hello, I've sent you a message with the solution I propose for your problem. Looking forward to working with you !

$100 USD in 2 days
(3 Reviews)
2.8
raisdhaka

pls see my PM

$50 USD in 2 days
(9 Reviews)
2.7
raaz0708

Hi ___________________________

$100 USD in 0 days
(1 Review)
1.8
webus

Hi! I have big expereince om work with different databases.

$30 USD in 0 days
(0 Reviews)
0.0
antonovdev888

Hi... Please check PMB.

$200 USD in 2 days
(0 Reviews)
0.0
deep89vnit

Hi, I went through your requirement and found that your requirement is exactly meeting our working profile. In short we can deliver your requirement on time..

$30 USD in 1 day
(0 Reviews)
0.0
marius63

Dear Sirs: I am an experienced software engineer specialized in these matters. I understand you specification and the samples files. I can provide an solution. Please refer to personal message for details. Rega More

$250 USD in 3 days
(0 Reviews)
0.0
AhlyM

Please check PM.

$30 USD in 1 day
(0 Reviews)
0.0
williamkamau

Thanks for considering this proposal already have a solution of reading and converting the number as it is read using php. Ready to accomplish task.

$30 USD in 1 day
(0 Reviews)
0.0