topic Replace function not working. Please help? in QlikView

Replace function not working. Please help?

Wed, 22 Apr 2015 16:08:20 GMT

Hi,

I am trying to replace below in script. But it is showing error

Replace(Lead,'Adam O'Balson','Adam O Balson') as Lead

Is there any wrong in above expression?

Thanks.

Re: Replace function not working. Please help?

stigchel — Wed, 22 Apr 2015 16:15:09 GMT

Try With

=Replace(Lead,'Adam O'&Chr(39)&'Balson','Adam O Balson')

Re: Replace function not working. Please help?

Thu, 23 Apr 2015 12:42:59 GMT

Thanks. tried this not working. Any solution please

Re: Replace function not working. Please help?

stigchel — Thu, 23 Apr 2015 12:56:10 GMT

This should be working as you can see in the attached example, maybe there is something else wrong. What is the error? Otherwise please share a qvw which demonstrates the problem.

Re: Replace function not working. Please help?

sunny_talwar — Thu, 23 Apr 2015 13:03:05 GMT

Why not try this instead:

=Replace(Lead, Chr(39), ' ')

Best,

Sunny

Re: Replace function not working. Please help?

PrashantSangle — Thu, 23 Apr 2015 13:11:30 GMT

Hi,

Use PurgeChar()

try like PurgeChar(FieldName,Chr(39))

Regards

Re: Replace function not working. Please help?

Thu, 23 Apr 2015 13:26:38 GMT

Thanks. It's working now. How can I change the same expression if I want to keep 'Adam O'Balson'

I have one more requirement to use in pivot chart expression as below. when I am using this it is showing error

If(Match(Lead,'Mitchet','Sony', 'Adam O'Balson'),Lead)

Re: Replace function not working. Please help?

stigchel — Thu, 23 Apr 2015 13:36:29 GMT

It's the same problem as ' is used by qlikview as text delimiter. Same solution:

If(Match(Lead,'Mitchet','Sony', 'Adam O'&Chr(39)&'Balson'),Lead)

Re: Replace function not working. Please help?

jonathandienst — Thu, 23 Apr 2015 13:39:27 GMT

This works in 11.2 SR9 (two single apostrophes):

If(Match(Lead, 'Mitchet', 'Sony', 'Adam O''Balson'), Lead)

Re: Replace function not working. Please help?

Thu, 23 Apr 2015 13:51:10 GMT

Thanks.

Re: Replace function not working. Please help?

Thu, 23 Apr 2015 13:52:22 GMT

Thanks for all answers.