Solved: Replace ' character in fileds - Page 2 - Qlik Community

Report Inappropriate Content · ‎2009-05-22

Hello,

Sorry for my poor english but i'm french.

I'd like to know how replace a quote character <'> in a field.

I tried to use the function <replace> using <"'"> in option :

replace(<field>, "'",'') but it doesn't work !

Can someone help me please !

qlikviewforum · ‎2012-10-08

I have already tried that but the output is something like below:

"""C:\Documents and Settings\MYUSER\Desktop\New Folder"""

rbecher · ‎2012-10-08

What means "output" in your context? STORE into text files?

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

qlikviewforum · ‎2012-10-08

Yes you are correct! In the stored txt file it is in the above format

rbecher · ‎2012-10-08

You should start a new thread with a sufficient problem description.

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

qlikviewforum · ‎2012-10-09

I have already started here but not able to get the solution from the experts yet!