Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Dynamic loading broken by single quotes

I am building dynamic load scripts based on header rows in CSV files.  The code works fine on my computer, loading various tables with slightly different structures, but the script errors on my client's system because QV is turning single quotes into multiple single quotes - 2, 3, 4, sometimes even 7 contiguous single quotes.  I have tried stripping the resultant load string of quotes, but on my client's system, when I put the single quotes back, QV turns them into two single quotes.  Both systems are running QV11 SR2.  Is there some setting to get around this?  

It looked like concat() would solve this string building issue, replacing multiple, looped ampersand concatenations with a single, clean statement, but I cannot figure out how to get the string created by concat() to expand within the load script.  It displays a string in a text box with single quotes intact, but adamantly refuses to expand as a load string in the ETL script.

1 Solution

Accepted Solutions
Not applicable

Re: Dynamic loading broken by single quotes

Solved and a tip 'o the hat to Dmitry Gudkov.   Forget about using string concatenation when single quotes are in the house.  Use concat() to put the string into a temporary table and peek() to get it out, quotes intact.

1 Reply
Not applicable

Re: Dynamic loading broken by single quotes

Solved and a tip 'o the hat to Dmitry Gudkov.   Forget about using string concatenation when single quotes are in the house.  Use concat() to put the string into a temporary table and peek() to get it out, quotes intact.

Community Browser