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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to replace double quotation marks in a string ??

Hallo together,
i have a Field with an Article description in this Field the Name of an Article is for example milk "extra dry" 1 ltr now i have to replace the " fom the string and set another char like * for example.
CHANGE and EREPLACE doesn't work
StringHandling.CHANGE(Var.Abez1,""","*")
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,
EREPLACE and CHANGE should both work, but you should probably escape the quot.
So for example: StringHandling.CHANGE(Var.Abez1,"\"","*")
Regards,
Arno