Stuck in Wildmatch() related issue

[sarfaraz_sheikh]

Dear All,

I am using below code..for clubbing the content of column into specific name

if(Wildmatch(purgechar(PROD_NAME_DESC,''),

'Contractor's All Risk Insurance',
'Contractor's Plant and Machinery Insurance',
'Erection All Risk Insurance',
'Machinery Breakdown Insurance'),'Engg',)

My concern is.... for all four product Engg should show as dimension but if we look at over the product more insightly....

There is two product name it as 1>

Contractor's All Risk Insurance   2 > Contractor's Plant and Machinery Insurance

This two product already has single inverted comma( ' ) attributed to them ..and we have to specify content of field in Single quotes( '' ) thrrough wildmatch function for achiving the desired output.

However  whenever  i am combining this product through wildmatch() ...i am getting error in expression ....Kindly suggest me what should i have to here in order to remove the single inverted comma from product.

Sarfaraz

[avinashelite]

can you please share the app??

[PrashantSangle · Accepted solution]

Hi,

Try like

if(wildmatch(Replace(Prod_Name_desc,chr(39),''),

'Contractors All Risk Insurance',
'Contractors Plant and Machinery Insurance',
'Erection All Risk Insurance',
'Machinery Breakdown Insurance'),'Engg')

Regards

[sarfaraz_sheikh]

Dear Max,

Thanks for solution .........now it is working as expected .......

Sarfaraz