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:


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)

14 freelancers are bidding on average $76 for this job


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)

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)

Hi, please check PM

$45 USD in 3 days
(16 Reviews)

Hi, please check p.m Thanks!

$50 USD in 5 days
(8 Reviews)

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)

pls see my PM

$50 USD in 2 days
(9 Reviews)

Hi ___________________________

$100 USD in 0 days
(1 Review)

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

$30 USD in 0 days
(0 Reviews)

Hi... Please check PMB.

$200 USD in 2 days
(0 Reviews)

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)

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)

Please check PM.

$30 USD in 1 day
(0 Reviews)

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)