Reading data from excel few cell values have double quotes How to include the double quotes while reading

Question

In excel sheet, I have a column which contains query in this format "sel * from ABC;" . Users will have to give the query with double quotes like this as spark engine process the query in this format.

In java code how can i read this value as it as without excluding the double quotes.

Currently it is read as

"\"select * from ABC;\"" .

how can i make it to

 "select * from from ABC;"

Answer 1

Hi, @Jyra,

You can use one Java function that is Java String Replaceall(): This method finds all occurrences of a sequence of characters matching a regular expression and replaces them with the replacement string. At the end of the call, a new string is returned by the function.

public class Career {
    public static void main(String args[]) {
        String str = "\"select * from ABC;\""
        String str2 = str.replaceAll("\"","");

);

System.out.println(str2);
    }
}

I hope this will help you.

Comments

HI Gitika, the problem is different. In excel it self i give the query in quotes. While java reads this it reads in "\"select * from abc\"" . In excel i gave it as "select * from abc"  [ including quotes].

Fixed this problem. While replacing the backslash, we have to give replace.("\\\\",""). this worked.

---

Hi, @Jyra,

That's great that you came up with a solution. Bingo!!