topic Re: Search-replace function in QlikView

Search-replace function

Mon, 17 Dec 2012 15:53:16 GMT

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

Miguel_Angel_Baeyens — Mon, 17 Dec 2012 15:56:14 GMT

Hi,

Use the function PurgeChar:

PurgeChar(FieldName, '"[]')

Hope that helps.

Miguel

Mon, 17 Dec 2012 16:09:42 GMT

Thanks Miguel. Works perfectly.