How to detect and fix wrong line breaks?

Moon · Jul 24, 2007#12007-07-24T15:24+00:00

Hello,

I have some problem with Log files where the layout is not good.

In fact, i will have Date / Time at the beginning of each line like this :

2007/07/24 07:05 : Comment / parameter / ...
2007/07/24 07:05 : Comment / parameter / ...
2007/07/24 07:05 : Comment / parameter / ...

But sometimes in my logs i've this :
2007/07/24 07:05 : Comment / parameter / ...
2007/07/24 07:05 :
Comment / parameter / ...
2007/07/24 07:05 : Comment / parameter / ...

What i want to do is to modify the layout to have date / time at each line.
(More easy to read

)

I have think of this solution :
Go to the beginning of each line
If the "first" characters are not 2007/07 (parameter ?

)
Do Key BACKSPACE
Else goto next line

My problem is : how to search 2007/07 ?

Thanx for you help and your courage to read me so far

Mofi · Jul 24, 2007#22007-07-24T16:45+00:00

Run this macro with macro property Continue if a Find with Replace not found checked:

InsertMode
ColumnModeOff
HexOff
UnixReOff
Top
Find RegExp "%#"
Replace All "MaRkEdChAr"
Find RegExp "%^(20[0-9][0-9]/[01][0-9]/[0-3][0-9]^)"
Replace All "#^1"
Find RegExp "^p^([~#]^)"
Replace All "^1"
Find RegExp "%#"
Replace All ""
Find MatchCase "MaRkEdChAr"
Replace All "#"

Add UnixReOn or PerlReOn (v12+ of UE) at the end of the macro if you do not use UltraEdit style regular expressions by default - see search configuration. Macro command UnixReOff sets the regular expression option to UltraEdit style.

The macro first searches for '#' at start of any line and replaces it with strange string "MaRkEdChAr".

Next the macro marks all lines with '#' at start of the line which starts with 20yy/mm/dd.

Then the macro deletes all DOS line terminations (CR+LF) where the next character is not '#'.

Last the inserted '#' at start of every line with a date is removed and every strange string "MaRkEdChAr" is replaced back to '#'.