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
 SQL Server Development (2000)
 Code to retrieve some perticular fields from txt

Author  Topic 

karan_eye
Starting Member

2 Posts

Posted - 2005-07-01 : 08:25:10
Hi,

There is one text file called mig.txt, the contents of which are pasted below.
-----------------------------------------------------------

******************************************************
Microsoft Exchange Migration Wizard, v(6.5.7226.4)
Start Logging: 07/01/05 15:20:30
******************************************************
[15:20:30] Mailboxes to be migrated from server blrkec37pdc:
sidharth

[15:20:30] Updating Active Directory.
[15:20:31] Updated mailbox information for sidharth in Active Directory.

[15:20:31] Migrating Mailboxes.
[15:20:31] Started migrating mailbox sidharth to server BLRKEC40PDC.
[15:20:33] Completed migrating mailbox for sidharth.

[15:20:33] Exchange Migration Wizard completed.

----------------------------------------------------------------

I want some particular fields to be extracted into a database table.
The one's indicated in the bold are the one's that are to be extracted...

Please help me out with a code that performs the above..


Thanks,

Charan.


Brian Kelley
Starting Member

1 Post

Posted - 2005-07-01 : 10:47:10
Easiest thing to do is use a scripting language to parse the text file. What are you proficient in (VBScript, JScript, Perl)?
Go to Top of Page
   

- Advertisement -