Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Parsing IIS logs in database for filename
Nevermind, I figured it out, thanks to a posting by Suresh (sgursahaney). For anyone trying to do something similar, REPLACE seems to be the key. It's ugly, but it works. This query removes all the spaces, and directories: select...- gcrist
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Parsing IIS logs in database for filename
I'd like to create a join between a column that contains filenames (such as '00001234.pdf') and an IIS inetlog table "target" column which records the path and filename (such as '/Mtracksdoc/topics/ct/00001234.pdf'). The '/Mtracksdoc/topics/' part never changes, but the directory above...- gcrist
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
