column re-alignment

hattori.hanzo · 03-02-2009, 11:36 PM

G'day,

How would I rearrange a list of entries from this:

192.168.1.23 2009/03/02 01:12:22 00:12:21:32:32:65

To:

2009-03-02 01:12:22,192.168.1.23,00:12:21:32:32:65

thanks & regards

TB0ne · 03-03-2009, 11:59 AM

Quote:

Originally Posted by hattori.hanzo

G'day,

How would I rearrange a list of entries from this:

192.168.1.23 2009/03/02 01:12:22 00:12:21:32:32:65

To:

2009-03-02 01:12:22,192.168.1.23,00:12:21:32:32:65

thanks & regards

There are lots of different ways. You can do it with bash, perl, ruby, python, C....what language? What have you tried already?

Udi · 03-03-2009, 01:14 PM

You can easily pass the list to a bash script or a bash function and loop over them:

for arg; do ...; done

You can also access the parameters as $1, $2, $3...

H_TeXMeX_H · 03-03-2009, 02:32 PM

This can be easily done with sed and awk, but I suspect this may be homework, so you'll have to try on your own first, maybe post what you might do.

Check here:
http://www.grymoire.com/Unix/

I'll give you a hint:

With awk you can use C-style printf statements.

Code:

awk '{ printf("%s", $1) }'

$1 is the first column delimited by whitespace ($2 is the second, etc.), %s tells it to format the output as a string, so maintain its current format in most cases.

Tinkster · 03-03-2009, 02:45 PM

Quote:

Originally Posted by hattori.hanzo

G'day,

How would I rearrange a list of entries from this:

192.168.1.23 2009/03/02 01:12:22 00:12:21:32:32:65

To:

2009-03-02 01:12:22,192.168.1.23,00:12:21:32:32:65

thanks & regards

G'day matey =} from the west-island ;)

Code:

echo 192.168.1.23 2009/03/02 01:12:22 00:12:21:32:32:65 | awk '{print gensub(/\//, "-", "g", $2)" "$3","$1","$4}'
2009-03-02 01:12:22,192.168.1.23,00:12:21:32:32:65

Close enough to what you want? ;)

Cheers,
Tink

hattori.hanzo · 03-03-2009, 04:36 PM

Hello mates,

Thanks for the responses. This is what I have so far in perl which appears to be working.

Code:

print ($time,",",$mac,",",$ip,",",$name,"\n");

Lovely, I will check out the awk statement, as bash would be my preference. 8-)

Now I just need to extract : from the mac address...

cheers,

Tinkster · 03-03-2009, 04:44 PM

Code:

echo 192.168.1.23 2009/03/02 01:12:22 00:12:21:32:32:65 | awk '{print gensub(/\//, "-", "g", $2)" "$3","$1","gensub( /:/, "","g",$4)}'

Cheers ;}

hattori.hanzo · 03-03-2009, 04:45 PM

Quote:

Now I just need to extract : from the mac address...

Dont worry about this, the function I am using has this ability so its all good.

regards,

hattori.hanzo · 03-03-2009, 04:46 PM

Quote:

Originally Posted by Tinkster

Code:

echo 192.168.1.23 2009/03/02 01:12:22 00:12:21:32:32:65 | awk '{print gensub(/\//, "-", "g", $2)" "$3","$1","gensub( /:/, "","g",$4)}'

Cheers ;}

Wow. that was quick. nice one.. thanks mate. :-)

ghostdog74 · 03-05-2009, 12:54 AM

Code:

echo "192.168.1.23 2009/03/02 01:12:22 00:12:21:32:32:65" | awk '{gsub(/\//,"-",$2);print $2,$3","$1","$4}'