Data Cleansing
(AutomateExcel) A useful method when performing data cleansing is simply 'Find and Replace'. Working example: From the toolbar select Edit > Replace… (or press CTRL + H) Enter the find and replace characters (the default is not case sensitive, if you require t
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 3651 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 3651]
updated 3651 (Automate Excel), inserted 0, updated 0, at 2012-05-30 20:52:20
