topic Re: Remove Apostrophe in the string in QlikView

Remove Apostrophe in the string

Mon, 06 Jul 2015 03:01:40 GMT

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?

Re: Remove Apostrophe in the string

sunny_talwar — Mon, 06 Jul 2015 03:05:15 GMT

Since you are using WildMatch, try this (use *)

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

Re: Remove Apostrophe in the string

Mon, 06 Jul 2015 03:29:07 GMT

Hi sunindia‌‌

Although the script works, it still doesn't group it to the COMMERCIAL OPERATIONS string.

Re: Remove Apostrophe in the string

sunny_talwar — Mon, 06 Jul 2015 03:31:20 GMT

Can you share a sample?

Re: Remove Apostrophe in the string

Mon, 06 Jul 2015 03:47:44 GMT

Hi sunindia,

as requested.

Re: Remove Apostrophe in the string

sunny_talwar — Mon, 06 Jul 2015 03:55:04 GMT

See if this helps:

If(WildMatch(Group, 'MARKETING & TRADING ,RESEARCH & DEV*'), 'COMMERCIAL OPERATIONS', Group) as Group

Re: Remove Apostrophe in the string

senpradip007 — Mon, 06 Jul 2015 04:05:33 GMT

PFA and reload the app; check with "NewGroup" field. Hope it will help you.

Re: Remove Apostrophe in the string

jagan — Mon, 06 Jul 2015 04:17:02 GMT

Hi,

Try this

If(Match(

Category,

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

Sample Load Script:

LOAD

If(Match(

Category,

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

INLINE [

Re: Remove Apostrophe in the string

timanshu — Mon, 06 Jul 2015 04:22:16 GMT

Hi Jarlee,

Write this :

This works precisely.

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

as there is a problem with this actual value. after DEV'T , there is a new line. So write above expression for this.

Find app attached.

Re: Remove Apostrophe in the string

Mon, 06 Jul 2015 05:20:40 GMT

hi sunindia its working now thanks.

Re: Remove Apostrophe in the string

qlikviewwizard — Mon, 06 Jul 2015 05:48:11 GMT

Hi jagan,

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

Re: Remove Apostrophe in the string

jagan — Mon, 06 Jul 2015 05:54:45 GMT

Hi,

PFA file for solution.

Regards,

Jagan.

Re: Remove Apostrophe in the string

qlikviewwizard — Mon, 06 Jul 2015 06:02:53 GMT

Hi jagan,

Thank You So much. I got it.

Re: Remove Apostrophe in the string

MarcoWedel — Mon, 06 Jul 2015 06:07:08 GMT

Re: Remove Apostrophe in the string

sunny_talwar — Mon, 06 Jul 2015 10:08:06 GMT

Awesome

I am glad I was able to help.

Best,

Sunny

Re: Remove Apostrophe in the string

MarcoWedel — Mon, 06 Jul 2015 11:04:24 GMT

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