Linux Archive

Linux Archive (http://www.linux-archive.org/)
-   CentOS (http://www.linux-archive.org/centos/)
-   -   Extract lines from text file (http://www.linux-archive.org/centos/694242-extract-lines-text-file.html)

Tony Molloy 08-15-2012 02:22 PM

Extract lines from text file
 
Hi,

I'm looking for a command to extract lines from a large text file, a
password file. A typical user has a username made from a letter
followed by their id-number.

m9718508:pw:9301:840: Lynch :/home/pgstud/m9718508:/bin/bash

So for instance if I need to extract lines where;

the 1st field, the username begins with an m
and
the 4th field, the group contains exactly 850

cat passwdfile | grep ^m | grep 850 > output

is close but fails if the value 850 appears outside the 4th field. In
the above example which should be ignored 850 appears in the username
and home directory and is therefore extracted.

Any ideas.

Thanks,

Tony
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

Rajagopal Swaminathan 08-15-2012 02:31 PM

Extract lines from text file
 
Greetings,

On Wed, Aug 15, 2012 at 7:52 PM, Tony Molloy <tony.molloy@ul.ie> wrote:
>
> Hi,
>
>
> So for instance if I need to extract lines where;
>
> the 1st field, the username begins with an m
> and
> the 4th field, the group contains exactly 850
>

cut -d: -f1,4 <input-filename>

--
Regards,

Rajagopal
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

wwp 08-15-2012 02:33 PM

Extract lines from text file
 
Hello Tony,


On Wed, 15 Aug 2012 15:22:10 +0100 Tony Molloy <tony.molloy@ul.ie> wrote:

>
> Hi,
>
> I'm looking for a command to extract lines from a large text file, a
> password file. A typical user has a username made from a letter
> followed by their id-number.
>
> m9718508:pw:9301:840: Lynch :/home/pgstud/m9718508:/bin/bash
>
> So for instance if I need to extract lines where;
>
> the 1st field, the username begins with an m
> and
> the 4th field, the group contains exactly 850
>
> cat passwdfile | grep ^m | grep 850 > output
>
> is close but fails if the value 850 appears outside the 4th field. In
> the above example which should be ignored 850 appears in the username
> and home directory and is therefore extracted.

Something like `grep -E '^m.+:.*:.*:850:'` maybe?


Regards,

--
wwp
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

Marcelo Beckmann 08-15-2012 02:36 PM

Extract lines from text file
 
Em 15-08-2012 11:22, Tony Molloy escreveu:
>
> Hi,
>
> I'm looking for a command to extract lines from a large text file, a
> password file. A typical user has a username made from a letter
> followed by their id-number.
>
> m9718508:pw:9301:840: Lynch :/home/pgstud/m9718508:/bin/bash
>
> So for instance if I need to extract lines where;
>
> the 1st field, the username begins with an m
> and
> the 4th field, the group contains exactly 850
>
> cat passwdfile | grep ^m | grep 850 > output
>
> is close but fails if the value 850 appears outside the 4th field. In
> the above example which should be ignored 850 appears in the username
> and home directory and is therefore extracted.
>
> Any ideas.


]$ cat testcentoslist
m9718508:pw:9301:840: Lynch :/home/pgstud/m9718508:/bin/bash
m9718308:pw:9301:850: Lynch :/home/pgstud/m9718508:/bin/bash
m9718208:pw:9301:840: Lynch :/home/pgstud/m9718508:/bin/bash
m9718508:pw:9301:840: Lynch :/home/pgstud/m9718908:/bin/bash

]$ cat testcentoslist | egrep ^m.*:.*:.*:850:
m9718308:pw:9301:850: Lynch :/home/pgstud/m9718508:/bin/bash



--
Marcelo Beckmann
Suporte Corporativo - suporte@webers.com.br
Webers Tecnologia - http://www.webers.com.br
Curitiba (PR) (41) 3094-6600
Rio de Janeiro (RJ) (21) 4007-1207
São Paulo (SP) (11) 4007-1207


_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos


All times are GMT. The time now is 01:44 PM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.