pattern matching lines using the date, and then joining the lines

[HIB049]

Hi Guys,

Was trying to attempt the below using awk and sed, have no luck so far, so any help would be appreciated.

Current Text File: The first line has got an "\n", and the second line has got spaces/tabs then the word and "\n"

TIME SERVER/CLIENT TEXT
02/03/2010 23:44:13 hostname02 hostname01 NBU status: 96, EMM status: No media is
available
01/03/2010 03:48:14 unknown hostname01 backup of client hostname01 exited with
status 96 (unable to allocate new media for backup,
storage unit has none available)
22/02/2010 19:44:09 hostname02 hostname01 NBU status: 96, EMM status: No media is
available

OUTPUT FILE:
TIME SERVER/CLIENT TEXT
02/03/2010 23:44:13 hostname02 hostname01 NBU status: 96, EMM status: No media is available
01/03/2010 03:48:14 unknown hostname01 backup of client hostname01 exited with status 96 (unable to allocate new media for backup, storage unit has none available)
22/02/2010 19:44:09 hostname02 hostname01 NBU status: 96, EMM status: No media is available

 

[feherke]

Hi

What have you tried so far and which is your problem ?


Feherke.

http://free.rootshell.be/~feherke/

 

[HIB049]

tried using awk '/[0-9]*\/[0-9]*\/[0-9]*/ { print $0; getline; print $0}', but this doesnt work.

 

[feherke]

Hi

You were quite close. Just need to :
[ul]
[li]Stop [tt]awk[/tt] to output the line separator at the end of non-final lines ( use [tt]printf[/tt] )[/li]
[li]Handle multiple trailing lines ( use [tt]while[/tt] )[/li]
[/ul]
But in my approach there would be a little change :
[ul]
[li]Set the [tt]ORS[/tt] ( Output Record Separator ) to nothing[/li]
[li]Output [tt]\n[/tt] ( new line ) when needed[/li]
[/ul]

awk -vORS= '/[0-9]+\/[0-9]+\/[0-9]+/{print"\n"}{sub(/^ +/," ")}1' /input/file

Note that with this approach there will be no newline at the end of the last line. If you need that too, just [tt]print[/tt] it in an [tt]END[/tt] block.

Feherke.

http://free.rootshell.be/~feherke/

 

[HIB049]

Thks feherke, that worked beautifully.