Contractor Name, Address, and Zip Code
YORK INTERNATIONAL CORPORATION
631 S RICHLAND AVE
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.
Click Here to Expand Forum to Full Width