Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-09-09 07:23 AM

Double Quotes in tOracleInput Query Causing Invalid Character Constant

Hi,
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.
Many thanks,
Brian

Labels (2)
Labels
174 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2016-09-19 02:25 AM
Author

have you tried using char function to replace the quotes? 
174 Views
0 Likes