Sed wraps some lines, not all

[kristo5747]

Greetings. I am using SED to cleanup files that are laid out like so:

ReceiverID=028936004663
SerialNumber=WD-WCAV95708405
Currenttemp=44C
PowerOnHours=3663h
ReceiverID=028923894902
SerialNumber=WD-WCAV9A766701
Currenttemp=49C
PowerOnHours=2215h

My boss wants files like this one to be tab ("\t") delimited like so

ReceiverID=...(tab)SerialNumber=...(tab)Currenttemp=...(tab)PowerOnHours=...(newline)
ReceiverID=...(tab)SerialNumber=...(tab)Currenttemp=...(tab)PowerOnHours=...(newline)...

1) first, I added a newline to mark each record

sed -i 's/h/h\n/g' infile

,
2) then, I added the the tab delimiter

    sed -i '/.$/N; s/.\n/\t/' infile

It works but strangely, not everywhere. This is the output I get

ReceiverID=...(tab)SerialNumber=...(tab???)
Currenttemp=...(tab)PowerOnHours=...(newline)
ReceiverID=...(tab)SerialNumber=...(tab???)
Currenttemp=...(tab)PowerOnHours=...(newline)

What am I missing?? I welcome your input. Thanks.

 

[feherke]

Hi

With your theory you have to repeat step 2 again.

But I would not do it. If other lines will contain "h", your code will fail. Anyway, your code is removing each group's first 3 lines' last character.

Personally I prefer to identify the key of the groups' last line :

sed -n ':l;H;n;/^PowerOnHours/!bl;H;s/.*//;x;s/\n//;s/\n/\t/g;p' /input/file

[gray]# or[/gray]

sed -n ':l;/\nPowerOnHours/!{N;bl};s/\n/\t/g;p' /input/file

But if you are sure there will be always groups of 4 lines, can be done easier :

sed -n 'N;N;N;s/\n/\t/g;p' /input/file

Feherke.

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

 

[PHV]

Another way, with awk:

awk '{x[NR%4]=$0}!(NR%4){for(i=1;i<4;++i)printf "%s\t",x[i];print}' infile

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kristo5747]

After *lots* of trials/errors, I got this (with help from people smarter than me):

#! /bin/bash
while read line; do
    [[ "$line" =~ PowerOnHours ]] && { 
        printf '%s\n' "$line"
    } || {
        printf '%s\t' "$line"
    }
done <myfile

I don't even need to add the newline after PowerOnHours (no added value, really). It gets me the output I was looking for

Receiver ID   = 028918576472    Serial Number = WD-WCAUK0635287 Current temp  = 50C     PowerOnHours  = 12972h
Receiver ID   = 028968505835    Serial Number = WD-WCAUH1726359 Current temp  = 48C     PowerOnHours  = 9591h

Thanks for your time.