| read text file [message #2776] |
Mon, 12 August 2002 17:17  |
hshah22222
Messages: 6
Registered: February 2002
|
Junior Member |
|
|
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
