Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
barjames
Starting Member
1 Post |
 Posted - 2007-03-02 : 05:39:44
|
| Never mind that I'm not in the right Topic...I'm probably not even in the right forum however any help is appreciated. I need to export data from our legacy system however in most cases I can only use the system's reports to get the data we need. I can grap the spooled binary file however I need to parse this file to make it useable. Any idea how to do this? Here's the top two records from the file:Unit Name Apartment 1Lessee's Name Dr Aamir Majeed & Lubna Aamir Lease Date 14Oct1996 Term 985yrs from 29/9/1806ANNUAL SERVICE CHARGE Amount 1527.83 Lease % 0.62510ANNUAL CAR PARK CHARGE Amount 0.00 Lease % 0.00000--------------------------------------------------------------------------------Unit Name Apartment 2Lessee's Name Ali Asif and Sobia Asif Lease Date 24May1996 Term 985yrs from 29/9/1806ANNUAL SERVICE CHARGE Amount 1527.83 Lease % 0.62510ANNUAL CAR PARK CHARGE Amount 262.75 Lease % 0.10750-------------------------------------------------------------------------------- |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-03-09 : 06:47:46
|
| Presuming the data is in fixed-width columns, I'd BCP (with a format file) or DTS it into a temporary SQL table, splitting the data into the required columns.You may have to do more than 1 "cleaning/formatting" pass on the data to get it working. |
 |
|
|
|
|
|
Parse Binary File