Steps:
-------
1) create a external table with these Contractor Name, Address, and Zip Code columns.

2) write a select statement:

DECLARE
lv_Address_v VARCHAR2(300);
BEGIN
SELECT Contractor_Name || REPLACE(Address,',','') || Zip_Code || ',' INTO lv_Address_v FROM external_table_name;
insert into Address_v values(lv_Address_v);
commit;
END;

try this hope this help U

"remove coma after YORK" -- in don't understand this paret. i hope u want to remove from address column.

Cheers!