Android Contacts – Remove Spaces / Line Breaks From Postal Address

UPDATE data
SET data1 = ltrim(ifnull(data4, '') || ' ' || ifnull(data5, '') || ' ' || ifnull(data6, '') || ' ' || ifnull(data7, '') || ' ' || ifnull(data8, '') || ' ' || ifnull(data9, '') || ' ' || ifnull(data10, ''))
WHERE mimetype_id IN (
		SELECT _id
		FROM mimetypes
		WHERE mimetype LIKE "%postal%"
		);

UPDATE data
SET data1 = REPLACE(replace(REPLACE(data1, x'0D0A', x'0A'), x'0D', x'0A'), x'0A', ' ')
WHERE mimetype_id IN (
		SELECT _id
		FROM mimetypes
		WHERE mimetype LIKE "%postal%"
		);