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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-22 : 22:51:14
|
| Michael Bahlitzanakis writes "Greetings:I am currently in the cross-roads of finishing a truly cool application. This system will house all incoming/outgoing e-mail on a SQL2K box. I've written an SP which binds itself to any type of e-mail system such as exchange etc and imports all mail onto tables. Now here's my question,Is there any way possible via T-SQL, to open and read a physical text file, onto perhaps a variable and attempt string parsing routines, i.e. REPLACE(), PATINDEX()?What I'm attempting in doing here is really parsing the body of the POP3/IMAP4 message. Ultimately, once the file has been modified and archived onto the database, it will obviously reside in a TEXT column for later retrieval. Now of course, I could attempt to manage and manipulate the data from a text column from the beginning and bypass the physical file, but if somehow I have the full arsenal of all the string functions at my disposal, I would rather do it via the file method if it exists. Your help is well appreciated.Now remember the file is by no means structured in anyway.PS. If you help me solve my problem, I will write you guys an article explaining how I did this SP..., Also I'm onto your Reader's challenge! :)Mike B. High Performance NetworksWeb: www.hpnet.com" |
|
|
|
|
|
Reading and modifying BLOBS effectively