Filter Data and remove traliling spaces,tabs,newline characters etc - Cacher Snippet

vibhasbhingarde

6/17/2017 - 5:23 AM

Filter Data and remove traliling spaces,tabs,newline characters etc

Filter Data and remove traliling spaces,tabs,newline characters etc

new_gist_file_0

first enable infile mode

 mysql --local-infile  -uroot -p 'Domestic Money Transfer'

UPDATE pincode set 	Districtname = TRIM(Replace(Replace(Replace(Districtname,'\t',''),'\n',''),'\r',''));

//Remove Unwanted Characters;

UPDATE tablename
SET columnToCheck = REPLACE(CONVERT(columnToCheck USING ascii), '?', '')
WHERE ...