Parse data dumped into a field

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Parse data dumped into a field

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-05 : 07:15:05

Anthony writes "How can I split this data into a table or tables using SQL Server 2000? It seems to be broken up into sections, I would love to be able to separate these files into another table and keep the headings. Thanks!

Data Dump:
OFA Note: 5th service on main floor of house. dd 031231 pm. ba = 6523
edenwood dr mississauga on l5n3h2!!!!!!!!SA Query !!!!!!!!Newly Built
Home Indicator: !!!!Additional Service Indicator: !!!!Service Address:
---------------------------------------------!!!!St #: 000007!!!!Sfx:
!!!!St name: LADBROOKE!!!!St type: RD!!!!Dir: !!!!Loct:Primary!!!!Locn:
Service!!!!Municipality: ETOBICOKE!!!!Province:ON!!!!Postal Code:
M9R2A7!!!!!!!!Create Order Section !!!!!!!!Bus/Res:R!!!!Contact Lang:
E!!!!Last Name: Morgan!!!!First Name: Jason!!!!Initial: !!!!Sales Code:
N422590!!!!!!!!Credit Info:---------------------------------
!!!!!!!!Employer: !!!!Hire Date: !!!!Employer TN: !!!!Co-User Name:
!!!!Contact TN: !!!!Contact Name: !!!!Contact TN: !!!!Estimated Long
Dist$: !!!!Directory Section !!!!!!!!act: I!!!!Directory Code:
SL!!!!Listing LastName: Morgan!!!!Listing FirstName: J!!!!!!!!NP Ind:
!!!!DDA!!!!Street Number: !!!!Street Name: !!!!Location Type:
!!!!Location Number: !!!!Municipalit
y: !!!!Province:!!!!Postal Code: !!!!!!!!Service & Equipment Section
!!!!!!!!Main Circuit: 4162424638!!!!REQ: !!!!PTN:
4162424638!!!!Act:I!!!!Resv#: R312183615!!!!CS: 1LR!!!!LST:
1LRCP!!!!Old LSP: BELL ONTARIO!!!!New LSP: BELL ONTARIO!!!!Add USOC:
------------------------------------------------!!!!!!!!USOC:
TTR!!!!Act: I!!!!Qty: 1!!!!USOC: RL911!!!!Act: I!!!!Qty: 1!!!!USOC:
1LRCP!!!!Act: I!!!!Qty: 1!!!!USOC: MMBVE!!!!Act: I!!!!Qty:
1!!!!Secondary Circuit: !!!!!!!!REQ: !!!!GTN: !!!!Add USOC
------------------------------------------------!!!!!!!!Enter remark
item!!!!Remark Fid Prompt:IJACK!!!!Remark Fid Value: 1!!!!Enter Service
Charge Details !!!!Type: IAI!!!!Quantity: 1!!!!Type: LIN!!!!Quantity:
1!!!!Billing Information Section!!!!!!!!Billing name and adress:
!!!!Enter A SBA Item !!!!Item: CCPTN!!!!Act: I!!!!Fid Value:
PrimaryCardholder!!!!Item: LANG!!!!Act: I!!!!Fid Value: English!!!!Due
Date Section !!!!!!!!Req Date: 2003-12-31!!!!Interval: AM!!!!Workforce
!!!!Save vi
sit indicator: R!!!!Workforce name: WESTAM!!!!Remarks: !!!!OPB (Order
Placed By):Jason!!!!Contact #: 9999999999!!!!CQT: Jason!!!!Primary
Contact TN: 9058246521!!!!Extension: !!!!Alternate Contact TN: !!!!"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-02-05 : 13:02:08

Could you describe the problem more? Is there more than one data set in the file? If so, just import the data into a staging table, then run T-SQL commands to get each data set out into its own table. You can use DTS for this.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources