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?

[sunny_talwar]

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

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

[#3]

Hi sunindia‌‌

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

[sunny_talwar]

Can you share a sample?

[#5]

Hi sunindia,

as requested.

[sunny_talwar · Accepted solution]

See if this helps:

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

[senpradip007]

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

[jagan]

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 [

Category

"MARKETING & TRADING ,RESEARCH & DEV'TFEEDSTOCK SUPPLY"

Test1

Test2 ];

Regards,

Jagan.

[timanshu]

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.

[#10]

hi sunindia its working now thanks.