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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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