How to truncate the second column from a dot (.)?

Question

INPUT:

10.175.192.16   vgxyxgf.de.foo.net  asdf    34efg
10.175.192.17   sdtds.de.foo.net    xyyxv   e5432
10.175.243.20   asdfycfb.us.foo.net dfvasf  34525

OUTPUT:

10.175.192.16   vgxyxgf
10.175.192.17   sdtds
10.175.243.20   asdfycfb

How can I make the OUTPUT? Like "awk '{SOMEMAGIC}' foo.txt

So I have the "INPUT" and I need a /etc/hosts file style OUTPUT... :\

Can you clarify your question?
– gabe.
Jan 27, 2012 at 1:01 — gabe., Jan 27, 2012 at 1:01

Steven Monday · Accepted Answer · 2012-01-26 05:07:40Z

8

Just for fun, here's a non-awk, non-sed answer:

cut -f1-4 -d. foo.txt

answered Jan 26, 2012 at 5:07

Steven Monday

1,45812 silver badges11 bronze badges

Add a comment |

SiegeX · Accepted Answer · 2012-01-26 04:53:56Z

5

With awk

awk '{sub(/\..*/,"",$2);$0=$1 "  "$2}1' foo.txt

With sed

sed 's/^\(\([^.]*\.\)\{4\}\).*$/\1/;s/\.$//' foo.txt

answered Jan 26, 2012 at 4:25

SiegeX

8,8893 gold badges34 silver badges23 bronze badges

I don't know how it works... but it work!! wow..
– LanceBaynes
Jan 26, 2012 at 4:28
1

@LanceBaynes Magic of course! What I did was replace everything after the first dot in the 2nd field $2 with a null string. I then told awk that the current line $0 is only made up of the first field $1 followed by two spaces followed by the (altered) second field $2
– SiegeX
Jan 26, 2012 at 4:36

Add a comment |

Community · Accepted Answer · 2017-04-13 12:36:55Z

2

Another awk solution, analogous to Steven's cut answer:

awk -F. -v OFS=. '{print $1, $2, $3, $4}' filename

Uses dots as the field separator, and prints the first 4 fields dot-separated.

CommunityBot

1

answered Jan 26, 2012 at 18:24

glenn jackman

86.1k16 gold badges119 silver badges172 bronze badges

Add a comment |

3 Answers 3