Previous Next

• 06-11-2008, 6:17 PM

  azag79 Joined on 06-11-2008, 6:04 PM Posts 2	Long Filenames Reply Contact Dear all! Is it possible to find long filenames (over 220 and more characters including path) with logparser? Is there a parameter for the where statement like this?  LogParser "SELECT Path, Name, Size FROM C:\*.* WHERE Name.Lenght >= 220 ORDER BY Name" -i:FS Thank you very much in advance. Best Regards Adam.

• 07-07-2008, 6:43 AM

  In reply to

  Anwarhusen Joined on 05-13-2008, 10:25 AM Posts 9	Re: Long Filenames Reply Contact Reply may be Late!!  Logparser sample queries contains a query that could help you. FilenameLengths.sql Anwarhusen http://www.aztecsoft.com Please refer Log Parser help for further reference

• 07-15-2008, 11:13 AM

  In reply to

  azag79 Joined on 06-11-2008, 6:04 PM Posts 2

  Re: Long Filenames Reply Contact Hi, your reply was very helpfull. We made it with another tool, but logparser is smarter and much more faster.  It's always the same, the solutuin was not far away ;-) Better to look in the path of the app, and you'll find the solution. But thanks very much for the hint. With "path" I get the required information of the files with lenght over 230 digits (incl. path). Thanks a lot. Here my solution for completion. Best regards adam. SELECT  Path,  STRLEN(Path) AS GesLen INTO test.csv FROM C:\*.* WHERE GesLen > 230 ORDER BY GesLen DESC