find an replace a particular character with another in strin

Question

I have a text file with a group of names.i  have to read each one and store it to database.But error comes for names like D'Souza.the error in unclosed quotation mark after the character string ' ........pls help me to solve this bug