Find Jobs
Hire Freelancers

SQL Query to Remove Characters in Phone Number

$10-30 USD

Chiuso
Pubblicato quasi 6 anni fa

$10-30 USD

Pagato al completamento
I need an sql query that will format all phone numbers in a table column and remove any characters(parentheses, dashes, and dots), and leave only numbers. I think there's 2 tables this needs to be done in.
Rif. progetto: 17229621

Info sul progetto

76 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
76 freelance hanno fatto un'offerta media di $23 USD
Avatar dell'utente
Hello There, How are you? I hope you are having great time in your life. I am having more than five years of experience in wordpress. I can make SQL query for you. That will remove all unwanted character from your phone number. Please let me know more about your requirement. Looking forward to work with you. Waiting for your quick and positive reply. Thanks RWS
$20 USD in 1 giorno
4,9 (479 valutazioni)
8,2
8,2
Avatar dell'utente
Hello, As an expert in SQL, i am very much interested to write the required query. Is it for ms sql server or MySQL ? Looking forward to have a positive response from you. Thanks
$28 USD in 1 giorno
5,0 (358 valutazioni)
8,2
8,2
Avatar dell'utente
Hello! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention SQL because this is my favorite field and database projects are among tasks I work with regularly and know exactly how to handle them. I'm a very experienced and skilled MS Access developer as you can easily check for yourself. You're welcome to visit my portfolio and get an idea of who I am and what services I deliver to my clients. You mention that you need somebody to create a query that will remove certain characters from 2 tables. This can be done by using SQL and I could do it for you in a couple of hours from awarding. I never ask for any payment in front. I claim milestone release once the project is completed and my client is happy with the result. I'm looking forward to hearing from you. Paris Pallas
$30 USD in 0 giorno
5,0 (253 valutazioni)
7,8
7,8
Avatar dell'utente
Hi i read your project description and would like to help you with it. i have more then 5 years of Webdesigning and Development experience with PHP and wordpress knowledge. i can finish your job in your timeframe professionally. Please message me in PM for more details. Have a look at my reviews to understand the work quality i deliver. Thanks
$25 USD in 1 giorno
5,0 (193 valutazioni)
7,2
7,2
Avatar dell'utente
Hi there. I do SQL and I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details.
$30 USD in 1 giorno
5,0 (529 valutazioni)
7,1
7,1
Avatar dell'utente
Hello It looks like puzzle at first look, but I have just googled SQL code for String replace operation that uses regular expression. I am sure it's possible to adapt it for your task
$25 USD in 2 giorni
5,0 (388 valutazioni)
6,8
6,8
Avatar dell'utente
I will do it immediately and i have 5+ experience in web development. I am sure will give you amazing results. if you have any questions please feel free to chat before ordering. My skills: - Magento 1 & 2 Theming and Customization - MySql - jQuery - HTML5 And CSS - Cakephp and Wordpress - AWS server setup specialist - Server administrator - Linux Thanks
$25 USD in 1 giorno
4,9 (131 valutazioni)
6,7
6,7
Avatar dell'utente
Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. what we could do is to parse each character in each row of the phone number field and if it is not in 0 to 9 then replace it with empty space. Would you like to keep the data as such and write a function to always return the data without characters? Or you like to replace the data? Either way is fine, I can do this at the mentioned budget. Thanks Roni
$30 USD in 1 giorno
5,0 (96 valutazioni)
6,7
6,7
Avatar dell'utente
Hi Sir, Good morning in America! Hey, So I am senior software developer with the C# Programming language and the Sql Server database. I am also strong with MySQL Server and Oracle database. I am able to help and start right now, as I am availalble out of wrapping up other project. Can you please ping me to discuss further? Kind regards, Sergio
$30 USD in 0 giorno
4,8 (93 valutazioni)
7,0
7,0
Avatar dell'utente
Hi, How are you? I am a database developer with over 5 years of development experience. I’ve carefully gone through your job post. I am very much interested in your project with all of your requirements. I feel very confident on your project and You will get the "Best Result" if you work with me. I work hard and you will surely get the result in a promised time. If you give me all information about your job, I can start working immediately. If you want, I will show you my previous work... Looking forward to discussing with you the details. Best regards.
$25 USD in 1 giorno
4,9 (40 valutazioni)
5,9
5,9
Avatar dell'utente
Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with more than 10 years of experience using SQL, queries, reports and dashboards design and construction, data warehousing, and related tasks and projects. I can write the SQL code for your requirement in two hours of work or less. Let me know via chat if you are interested. Thanks.
$25 USD in 1 giorno
4,9 (25 valutazioni)
6,0
6,0
Avatar dell'utente
Project Description I need an sql query that will format all phone numbers in a table column and remove any characters(parentheses, dashes, and dots), and leave only numbers. I think there's 2 tables this needs to be done in.
$15 USD in 1 giorno
4,9 (122 valutazioni)
5,8
5,8
Avatar dell'utente
I have similiar queries done, please contact me if you need the script quick and cheap, i will be available for you :)
$10 USD in 0 giorno
5,0 (58 valutazioni)
5,8
5,8
Avatar dell'utente
Hi, my name is Andrey. I have extensive experience with accounting systems, CRM, ERP, web-based databases, reports(xlsx,docx,pdf). For example in my portfolio i have some projects. Let's see them. All this projects have many tables in database and required complex queries from developer. I have some questions about your project: 1. What is RDBSM(MySQL, PostgreSQL, MSSQL)? 2. Hom much data on table that contains phone number? I am qualified for this project and sure that i successfully finish the project so i bid. Thank you.
$25 USD in 10 giorni
5,0 (15 valutazioni)
5,1
5,1
Avatar dell'utente
Dear Sir, I'm expert at Sql check as i'm MCITP, please message me to start this project. Kind Regards, NourElDeen
$19 USD in 0 giorno
5,0 (43 valutazioni)
5,3
5,3
Avatar dell'utente
Hi there. I am very much interested in updating your phone numbers table to remove all characters on the entries except the numbers. I am an experienced website developer focused on creating modern websites using PHP, MySQL, HTML5, CSS and JavaScript. I also use popular frameworks like Bootstrap, WordPress, Foundation, AngularJS and Codeigniter. Get to know me more by visiting my profile here https://www.freelancer.com/u/earvinpiamonte. Hope to hear from you soon. Thanks.
$10 USD in 0 giorno
4,9 (110 valutazioni)
5,5
5,5
Avatar dell'utente
I am having more than 9 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and skills.
$30 USD in 1 giorno
5,0 (38 valutazioni)
5,3
5,3
Avatar dell'utente
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
$25 USD in 10 giorni
4,7 (30 valutazioni)
5,2
5,2
Avatar dell'utente
Hello, I am an expert in SQL, and can do this for you within 10 minutes max. Available to do right now. Regards
$30 USD in 1 giorno
5,0 (23 valutazioni)
4,7
4,7
Avatar dell'utente
Hi i have expertise in slq server and please let me know di we have also characters in the column or not so that i wil modify my query and let you know
$30 USD in 1 giorno
4,8 (23 valutazioni)
4,6
4,6

Info sul cliente

Bandiera: UNITED STATES
Nashua, United States
5,0
3
Metodo di pagamento verificato
Membro dal giu 24, 2018

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.