Contractor Name, Address, and Zip Code
YORK INTERNATIONAL CORPORATION
PURCHASING DIVISION
631 S RICHLAND AVE
YORK, PA
174033445

Contract_v = varchar2 ''contractor,name,and Zipcode);
Address_v = null;

Above is text file. want to read it in Oracle (preferably)or SQL Server.After reading Contractor Name,address,and Zip Code, I want to substring /concat all 4 lines (including tabs) and remove coma after YORKand put all 4 lines in as one field called Address_v and add ',' at the end (after zip code).

Thanks for the help.