How to replace ' with empty string in Java
java, quotes, replace
Solution
Strings are immutable so you'll receive a new instance. Try
data = data.replace("'", "");
Your Edit
Check the return values of `getString()` - you could get your `NPE` because your database table contains `null` values in one of the columns `spl_char` or `replace_with`.
Problem
How can I replace single quote ' with empty string in Java. I tried following but doesn't seem to be working. ``` String data="Sid's den"; data.replace("'", ""); data.replaceAll("'", ""); ``` Thanks in advance. Any help is much appreciated.(Output should be: Sids den) Thanks guys for your responses. I guess I should have been more clear about my question. Basically I am getting special characters from the table and with what value we have to replace that also from the same table. Here is snippet of the code: ``` query = "select spl_char, replace_with from entcon_splchars"; ptsmt = DBConnector.sqlConnection.prepareStatement(query); rs = ptsmt.executeQuery(); while (rs.next()) { if(data.contains(rs.getString("spl_char"))){ data = data.replace(rs.getString("spl_char"),rs.getString("replace_with")); } } ``` so whenevr in the data we have special character ' then I am facing nullpointer exception. Please suggest how to go ahead with this?