https://community.qlik.com/t5/Talend-Studio/Double-Quotes-in-tOracleInput-Query-Causing-Invalid-Character/m-p/2338073#M106349 <P>Hi,<BR />I am using an INSTR in my SQL query to find the position of the next double quote in the data I am querying. I have tried using backslashes however I still get the Invalid Character Constant. Is there any method in dealing with the double quotes. For the purposes I won't get into I need this query to be extracted using SQL not later with Java in a tMap for instance.<BR />Many thanks,<BR />Brian</P> Fri, 09 Sep 2016 11:23:06 GMT Anonymous 2016-09-09T11:23:06Z https://community.qlik.com/t5/Talend-Studio/Double-Quotes-in-tOracleInput-Query-Causing-Invalid-Character/m-p/2338073#M106349 <P>Hi,<BR />I am using an INSTR in my SQL query to find the position of the next double quote in the data I am querying. I have tried using backslashes however I still get the Invalid Character Constant. Is there any method in dealing with the double quotes. For the purposes I won't get into I need this query to be extracted using SQL not later with Java in a tMap for instance.<BR />Many thanks,<BR />Brian</P> Fri, 09 Sep 2016 11:23:06 GMT https://community.qlik.com/t5/Talend-Studio/Double-Quotes-in-tOracleInput-Query-Causing-Invalid-Character/m-p/2338073#M106349 Anonymous 2016-09-09T11:23:06Z https://community.qlik.com/t5/Talend-Studio/Double-Quotes-in-tOracleInput-Query-Causing-Invalid-Character/m-p/2338074#M106350 have you tried using char function to replace the quotes?&nbsp; Mon, 19 Sep 2016 06:25:53 GMT https://community.qlik.com/t5/Talend-Studio/Double-Quotes-in-tOracleInput-Query-Causing-Invalid-Character/m-p/2338074#M106350 Anonymous 2016-09-19T06:25:53Z