Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
can you please share the app??
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
Dear Max,
Thanks for solution .........now it is working as expected .......
Sarfaraz