Replace () / . characters in phone numbers with dashes (MySQL database)

If you have a MySQL database containing phone number records in varying formats, you may want to standardize them. New records can easily be handled by checking data entry against your desired format (via JS or whatever method you like). However, existing records must be dealt with. That is where an UPDATE statement combined some handy MySQL functions can assist us: // Replace forward slash with dash UPDATE db_phonenumbers SET phone_field = REPLACE(phone_field, ‘/’, ‘-‘) // Replace close parenthesis with

Tax notes

https://ttlc.intuit.com/questions/2231912-need-help-regarding-cost-basis-for-a-1099-s-proceeds-from-real-estate-sale-city-reported-their-purchase-of-an-18-easement-to-extend-sewer-main-down-the-driveway-of-my-rental-property-to-irs-using-a-1099-s https://ttlc.intuit.com/questions/1772542-received-a-1099-s-for-road-right-of-way-permanent-easement-and-2-temporary-easements-how-should-i-enter-this https://ttlc.intuit.com/questions/2211264-i-have-a-1099-s-this-is-for-the-sale-of-land-right-of-way-to-a-utility-company http://www.portal.msue.msu.edu/objects/content_revision/download.cfm/revision_id.582335/workspace_id.580668/Oil%20&%20Gas%20Income%20Tax%20Consideration%20for%20Farm%20&%20Forest%20Lands.pdf/ http://www.aicpa.org/Publications/TaxAdviser/2014/march/Pages/Kebodeaux_mar2014.aspx  

Printable Chase Deposit Slips [SCAN/JPG/PDF]

I have been a longtime Chase customer but unfortunately they do not have ANY ATMs or branches around here. Deposit by mail can be pretty handy but the problem with that is that I often run out of deposit slips. The last time I checked the box on their deposit envelope for them to mail me more they sent me one deposit slip 🙁 [NOTE: PRINTABLE DEPOSIT SLIP REMOVED, TO BE UPDATED WITH REVISED VERSION. -2016_09_10] I have printed these and

Which X220 USB port is the USB 3.0 one? [SOLVED]

Q.Which X220 USB port is the USB 3.0 compatible? A. It is the ‘blue’* one, the rearmost USB port located on the left side of the laptop near the fan exhaust vent. You can see a photo of the port here: The other two ‘black’ ports are regular USB 2.0 ports. *Please note only the i7 X220’s have a USB 3.0 port, the i3 and i5 models do not 🙁 If you have an X220 i3 or i5 model and

Acer Aspire M5 583P wifi driver fix

Q. Here us a wifi driver question from a reader comment: hello, coming to u again for some help, this time im upgrading athe hdd to an ssd on an Acer Aspire M5 583p-9688. here is a rundown on what ive attempted. cloned original hdd to ssd using paragon software ( was successful when i cloned the hdd for the asus laptop). physically swapped the drives. f12 settings changed UFEI boot settings to Legacy, placed SSD on top of the

BCM20702A0 Dell drivers for Windows 8.1 [SOLVED!]

Q. Hello, I have a Dell laptop running a clean install of Windows 8.1 but I have an Unknown Device ‘BCM20702A0’… do you know what driver I can download to to fix it? A. Here is the download link for the driver that should solve your BCM20702A0 Unknown Device issue: mirror (to be added), Dell dl link     Supported Laptop/Notebook models: Systems Latitude E5420 Latitude E5430 Latitude E5520 Latitude E5530 Latitude E6220 Latitude E6230 Latitude E6320 Latitude E6330 Latitude E6420

Safely install ImgBurn without OpenCandy malware

Without a doubt ImgBurn is an awesome ISO creation too. However, at some point in the past they started bundling OpenCandy with ImgBurn. OpenCandy is an adware application that many people feel falls within the definition of malware or spyware.  This is obviously quite a bummer! From some of the licensing text and the way the options are presented during installation it seems like OpenCandy installation is inevitable. 🙁 However, if you are willing to check some options and uncheck some

Combine SSD or HDD boot and data partitions on Windows 8

*NOTE: I highly recommend backing up your data and creating restore media before trying ANY of these methods, just in case something goes awry! Today Antony asked the following question: Now that the ssd is successfully installed, my drive is divided into two, in My Computer ihave the Local disk that has the OS inside of it, and i have another drive that has the rest of my free space from the SSD, is there a way to combine the