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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search-replace function

Hi,

My data has a column called Keywords where some of the keywords have quotation marks " or brakets []. For example:

"yellow house"

"yellow gate"

[red house]

I would like to clean this field by removing quotations and brakets so it looks like this:

yellow house

yellow gate

red house

How can I do this in QV?

Thanks

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

Use the function PurgeChar:

PurgeChar(FieldName, '"[]')

Hope that helps.

Miguel

View solution in original post

2 Replies
Miguel_Angel_Baeyens

Hi,

Use the function PurgeChar:

PurgeChar(FieldName, '"[]')

Hope that helps.

Miguel

Not applicable
Author

Thanks Miguel. Works perfectly.