Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Replace ' character in fileds

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 !

14 Replies
qlikviewforum
Creator II
Creator II

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

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

rbecher
MVP
MVP

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

Astrato.io Head of R&D
qlikviewforum
Creator II
Creator II

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

rbecher
MVP
MVP

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

Astrato.io Head of R&D
qlikviewforum
Creator II
Creator II

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

http://community.qlik.com/message/267021#267021