Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
vweilandosmose
New Contributor II

Replace a quote (') with a blank

How do I replace a quote (') in a text field with a space ( )? I want to lookup the city, but my lookup file contains 'O Fallon' for the city O'Fallon. I tried to use replace([City],''',' ') but that did not work. Is there an escape character?

Tags (1)
3 Replies

Re: Replace a quote (') with a blank

May be this

Replace(City, Chr(39), ' ')

thiago_justen
Valued Contributor III

Re: Replace a quote (') with a blank

You can also use:

PurgeChar (City,Chr (39))

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
vweilandosmose
New Contributor II

Re: Replace a quote (') with a blank

That worked. Thanks!

Community Browser