Remove Apostrophe in the string

[#1]

I want to group a string into another group using wildmatch but the problem is that this string has a special character inside of it (see code)

=if(WildMatch(Group, 'MARKETING & TRADING ,RESEARCH & DEV'T FEEDSTOCK SUPPLY', )  , 'COMMERCIAL OPERATIONS' , Group)

The MARKETING & TRADING , RESEARCH & DEV'T FEEDSTOCK SUPPLY has a apostrophe between it.

Is there a way around this problem?

[qlikviewwizard]

Hi jagan,

I tried with your script. But not working. If possible, could you please attach the sample file. Thank you.

[jagan]

Hi,

PFA file for solution.

Regards,

Jagan.

[qlikviewwizard]

Hi jagan,

Thank You So much. I got it.

[MarcoWedel]

see also

Escape sequences

hope this helps

regards

Marco

[sunny_talwar]

Awesome

I am glad I was able to help.

Best,

Sunny

[MarcoWedel]

If(Match(Category,'MARKETING & TRADING ,RESEARCH & DEV''TFEEDSTOCK SUPPLY')  , 'COMMERCIAL OPERATIONS', Category) AS Group