smithveg - 2007-09-18

Hi,

I copy and paste my data from Excel to Notepad++.
It bring me a lot of tab, and extra spaces.

How do i eliminate (remove) the extra spaces as below?

INSERT INTO pack_items(items_id,items_code,items_particular,items_price,items_curr,items_unit,suppliers_id, category_id) Values (    2    ,trim('    HW6DH-COOPM     '),trim('    M6CPULS COOP - ( 6073/7232 )     '),    0.0850    ,trim('    RM     '),trim('    Pcs     '),    2,    1);

Thanks.