500 Meg logfiles

[Jesus4u]

We have 500 Meg logfiles that need to be parsed but the CRAPPY thing about it is that I first have to eliminate these unnecessary empty spaces at the end of the files for our SQL DTS to work correctly.

What would you suggest?

Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

 

[paulbent]

The Trim() function will strip leading and trailing space chars.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk