Win500 Problem with Activity log and Excel

[edt]

When sucking the Win500 Activity log into Excel I keep winding up with;

data
blank line
data
blank line
data
blank line
data
blank line

Except deleting the blank line one at a time is there a method to get rid of the blank line?

Is there invisible data in the blank line that can be deleted with a global command?

I've tried >Data>Sort and still end up with data/blank line.

Thanks...

[smason]

I'm not sure the best answer, but a quick workaround in Excel is
select all, click data, filter, advanced filter and check the unique records only button.
I'll think all but one blank line is duplicate, and will filter it.
You can leave it filtered, or copy/paste it into a fresh sheet.

[DonS]

The activity log file has extra carriage return (0x0D) characters on each line. Instead of ending with CR-LF, each line ends with CR-CR-LF.

I'll investigate.

[DonS]

Fixed in version 1.82.

Stupid library converting LF to CRLF (or stupid programmer for not reading the docs).

[edt]

Originally Posted by smason

I'm not sure the best answer, but a quick workaround in Excel is
select all, click data, filter, advanced filter and check the unique records only button.
I'll think all but one blank line is duplicate, and will filter it.
You can leave it filtered, or copy/paste it into a fresh sheet.

Thanks all for the advice. And thanks Don for fixing the problem so fast.

[fmon]

Originally Posted by edt

And thanks Don for fixing the problem so fast.

I marveled about that also when I read his two replies yesterday. 20 minutes? I can't even type that fast.