Remove\Replace the data in the table

pavanthota — Mon, 25 Feb 2013 15:12:32 GMT

Hi,

I have the data below like this

Sample:

A B C

a,b(sample),c k3

n(sample),m k3(sample),b

v k3(sample), x s2, y

;

I want to find (sample), k3(sample),s2 and k3 these strings in entire table irrespective of colums replace with null or remove the data in the table.

Could you please help me anyone to find out the answer

Thanks,

Pavan

Re: Remove\Replace the data in the table

Wed, 27 Feb 2013 09:53:32 GMT

Hi ,

I think you need to use replace() function for each individual column..

Please find the attached Application..

Hope it gives you some insight!!!

Thanks

Bhaskar