[SOLVED] show line have repated # four time by awk

phpshell · 06-20-2013, 08:34 AM

File
1111,2#4#5
2222,3#7#9#8#9
3333,2#7#8
4444,5#7#8#8#

Output should be
2222,3#7#9#8#9
4444,5#7#8#8#

Due to # repated 4 time
Thanks in advance for your support

smallpond · 06-20-2013, 08:53 AM

Code:

awk '/#.*#.*#.*#/' <foo
2222,3#7#9#8#9
4444,5#7#8#8#

grail · 06-20-2013, 09:11 AM

Code:

awk '/(.*#){4}/' file

danielbmartin · 06-20-2013, 09:24 AM

OP asked for an awk solution and got two of them.

As a learning exercise I tried to make a sed solution
and failed, probably due to "greedy" matching.

Code:

sed '/#.*#.*#.*#/p' $InFile >$OutFile

Please show how to do this with sed and/or grep.

Daniel B. Martin

smallpond · 06-20-2013, 09:41 AM

Here's Perl for free:

Code:

perl -ne '/#.*#.*#.*#/ && print' <foo
2222,3#7#9#8#9
4444,5#7#8#8#

phpshell · 06-20-2013, 11:22 AM

Quote:

Originally Posted by smallpond

Code:

awk '/#.*#.*#.*#/' <foo
2222,3#7#9#8#9
4444,5#7#8#8#

Many thanks for you

But if there are other column such as below and need to apply only on $2
By use
Awk -F,

1111,2#4#5
2222,3#7#9#8#9,sample#only
3333,2#7#8
4444,5#7#8#8#,sample##

grail · 06-20-2013, 11:24 AM

Sed:

Code:

sed -rn '/(.*#){4}/p' file

Grep:

Code:

grep -E '(.*#){4}' file

Ruby:

Code:

ruby -ne 'puts $_ if /(.*#){4}/' file

grail · 06-20-2013, 11:25 AM

Well I believe everyone has provided several examples and alternatives ... maybe you should have a go and see if you can extend one to solve your new criteria.

phpshell · 06-20-2013, 11:26 AM

Quote:

Originally Posted by grail

Code:

awk '/(.*#){4}/' file

Dear grail
It doesn't work with me not show any result
I like becuse it is very short command is there any missed

grail · 06-20-2013, 11:28 AM

What version and type of awk are you using?

Mine is:

Code:

$ awk --version
GNU Awk 4.1.0, API: 1.0 (GNU MPFR 3.1.2, GNU MP 5.1.2)

phpshell · 06-20-2013, 11:32 AM

GNU Awk 3.1.7
Copyright (C) 1989, 1991-2009 Free Software Foundation.

I think i have to update ..many thanks to you all

phpshell · 06-20-2013, 11:39 AM

Quote:

Originally Posted by phpshell

Many thanks for you

But if there are other column such as below and need to apply only on $2
By use
Awk -F,

1111,2#4#5
2222,3#7#9#8#9,sample#only
3333,2#7#8
4444,5#7#8#8#,sample##

awk -F, '$2~/#.*#.*#.*#/' file
2222,3#7#9#8#9
4444,5#7#8#8#

danielbmartin · 06-20-2013, 12:01 PM

Quote:

Originally Posted by phpshell

GNU Awk 3.1.7
Copyright (C) 1989, 1991-2009 Free Software Foundation.

I think i have to update ..many thanks to you all

To run with back-level awk, try this variation of grail's code ...

Code:

awk  --re-interval '/(.*#){4}/' $InFile >$OutFile

Daniel B. Martin

chrism01 · 06-20-2013, 07:32 PM

2 Perl variations

Code:

# match comma then any single char followed by # up to 4 x #
perl -ne '/,.#.#.#.#/ && print' t.t

# as above, but single char must be single digit
perl -ne '/,[0-9]#[0-9]#[0-9]#[0-9]#/ && print' t.t

David the H. · 06-23-2013, 07:58 AM

If all you want to do is print the matching lines, then grep is almost certainly the most efficient option, as posted by grail before. That's exactly what it was designed to do, after all. If you don't have gnu grep with extended regex (which supports the {..} interval matching), then you just have to build the entire expression by hand.

Code:

grep -E '([0-9]#){4}' input.txt
grep '[0-9]#[0-9]#[0-9]#[0-9]#' input.txt

awk would only have to be used if the matching pattern needs to appear in a specific column, and there's a chance that the same pattern could occur in other columns as well. And even then a more specific regex for grep could likely be designed instead.

I also think it's a not a good idea to use ".*" in this kind of match. Since "*" is greedy, you run a real risk of it consuming more than you want it to. Good regular expression design is careful to match only the intended pattern.

And just to clarify, gnu awk from version 4 interprets {..} by default. For versions before that you need to use the --re-interval option to enable it. Some other versions of awk may not support it at all (e.g. mawk).