http://forums.iis.net/1141.aspxDiscussion of input formats such as ADS, BIN, COM, CSV, TSV, ETW, EVT, FS, HTTPERR, IIS, IISODBC, IISW3C, NCSA, NETMON, REG, TEXTWORD, TEXTLINE, URLSCAN, and W3CenCommunityServer 2007 SP1 (Build: 20510.895)http://forums.iis.net/thread/1902349.aspxThu, 30 Apr 2009 00:55:21 GMT50bcf3b4-f6fe-4638-adff-0c150e922e99:1902349cci0http://forums.iis.net/thread/1902349.aspxhttp://forums.iis.net/commentrss.aspx?SectionID=1141&PostID=1902349<p>Maybe I should re-phrase - if I were to perform a word count on my previous post, it would show</p> <p>&nbsp;Text&nbsp;&nbsp; CountofText</p> <p>obtain&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</p> <p>&quot;obtain&quot;&nbsp;&nbsp;&nbsp;&nbsp; 1</p> <p>&#39;obtain&#39;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</p> <p>&nbsp;</p> <p>but I would like the SQL to be written in a way to show</p> <p>&nbsp;obtain&nbsp;&nbsp;&nbsp;&nbsp; 4</p> <p>If this cannot be done with the TextInputFormat perhaps another way?</p> <p>TIA&nbsp; Stan&nbsp;&nbsp;</p> <p>&nbsp;</p>http://forums.iis.net/thread/1901960.aspxMon, 27 Apr 2009 10:38:44 GMT50bcf3b4-f6fe-4638-adff-0c150e922e99:1901960cci0http://forums.iis.net/thread/1901960.aspxhttp://forums.iis.net/commentrss.aspx?SectionID=1141&PostID=1901960<p>Can the SQL statement for the Textword input be so specified that you can obtain or &quot;obtain&quot; or &#39;obtain&#39; a word count without regards to punctuation, i.e. the word obtain would be counted 4 times rather than 2.&nbsp; Stan</p>