Android Contacts – Remove Non Numbers From Phone

Posted on By David Kittell 
UPDATE data
SET data1 = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(data1, '.', ''), '+', ''), ' ', ''), ')', ''), '-', ''), '(', '')
WHERE mimetype_id IN (
		SELECT _id
		FROM mimetypes
		WHERE mimetype LIKE "%phone%"
		)
	AND (
		data1 LIKE '%+%'
		OR data1 LIKE '%.%'
		OR data1 LIKE '%-%'
		OR data1 LIKE '% %'
		OR data1 LIKE '%(%'
		OR data1 LIKE '%)%'
		);
Originally Posted on February 21, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Android SQLite Code SQL SQLite

Related Posts

Token String

Posted on

This PHP function will assist in splitting a string based on characters. $string = "This istan examplenstring"; /* Use tab and newline as tokenizing characters as well */ $tok = strtok($string, " nt"); while ($tok !== false) { echo "Word=$tok<br />"; $tok = strtok(" nt"); } $first_token = strtok(‘/something’, ‘/’);…

Read More

Batch File Replace Text In Text File

Posted on

del /q FileList.txt del /q CleanFileList.txt dir *.* /O:N /b /s /d /A:-D > filelist.txt ssr "C:TempFolder"= "" filelist.txt > filelist_new.txt ssr "filelist.txt"= "" filelist_new.txt > FileList.txt del Filelist_new.txt ssr "ListFiles.bat"= "" FileList.txt > CleanFileList.txt del FileList.txt Originally Posted on August 4, 2014Last Updated on October 26, 2015 All information…

Read More