Linux shell script: How to match substring with regex

Question

How can I get all "clid's" which has the "client_type=0"? The pipe char "|" seperates each client info. The text, which I have is just one line:

clid=2 cid=3346 client_database_id=5153 client_nickname=xLukas\s\p\sLukas client_type=0|clid=3 cid=3346 client_database_id=1 client_nickname=powered\sby\sMirWayne.DE client_type=1|clid=4 cid=3346 client_database_id=9661 client_nickname=Number\sone client_type=0|clid=5 cid=3469 client_database_id=1 client_nickname=powered\sby\sMirWayne client_type=1|clid=6 cid=1716 client_database_id=1 client_nickname=FG\sBot client_type=1|clid=7 cid=3469 client_database_id=9661 client_nickname=Number\stwo client_type=0|clid=8 cid=1762 client_database_id=4351 client_nickname=pr0zkillz1x\pTobi client_type=0|clid=9 cid=1764 client_database_id=5160 client_nickname=xL1mited\s/\sMax client_type=0|clid=10 cid=1716 client_database_id=9704 client_nickname=Sebi client_type=0|clid=13 cid=3346 client_database_id=4336 client_nickname=checker284\s\p\sSebbo client_type=0|clid=19 cid=1762 client_database_id=9312 client_nickname=pr0skillz1x\pDanie client_type=0|clid=30 cid=3346 client_database_id=9697 client_nickname=TeamSpeakUser client_type=0|clid=33 cid=1716 client_database_id=1 client_nickname=serveradmin client_type=1

I need alle clid's, which has the client_type=0 in an extra line. For example like that:

    clid=2
    clid=3
    clid=4
    clid=5
    ...

My current solution is not working:

    cat clientlist.txt | grep -Eo "clid=[0-9]+[\d\D]*client_type=0" | grep -Eo "clid=[0-9]+"

Can somebody help?

cat a file into grep? Surely you jest! grep ... clientlist.txt | ... saves about a billion CPU cycles per invocation. — Jens
– Jens, Commented Nov 28, 2013 at 8:13
What's better? I would use each working solution, but currently I have no. — checker284
– checker284, Commented Nov 28, 2013 at 8:15
It's better to avoid a useless cat and a useless pipe. You don't drive with the brakes engaged, or do you? — Jens
– Jens, Commented Nov 28, 2013 at 9:03

devnull · Accepted Answer · 2013-11-28 08:17:24Z

1

The pipe char "|" seperates each client info.

Making use of this information, you can say:

tr '|' '\n' < clientlist.txt | grep -Po 'clid=\d+(?=.*client_type=0)'

For your input, it'd result in:

clid=2
clid=4
clid=7
clid=8
clid=9
clid=10
clid=13
clid=19
clid=30

answered Nov 28, 2013 at 8:17

devnull

124k33 gold badges247 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

anubhava · Accepted Answer · 2013-11-28 08:15:38Z

1

Using sed:

tr '|' '\n' < file | sed -n '/client_type=0/s/\(clid=[0-9]*\).*$/\1/p'
clid=2
clid=4
clid=7
clid=8
clid=9
clid=10
clid=13
clid=19
clid=30

answered Nov 28, 2013 at 8:15

anubhava

790k67 gold badges603 silver badges671 bronze badges

10 Comments

Oliver Matthews Over a year ago

close, but not quite - you need to handle the delimiter, so the correct version is sed -n -e 's/|/\n/' -e '/client_type=0/s/$clid=[0-9]*$.*$/\1/p'

anubhava Over a year ago

@OliverMatthews: Thanks I updated, I thought there are new lines after pipe in input file.

devnull Over a year ago

I started making use of grep more often after looking at your posts, you seem to have abandoned it!

Oliver Matthews Over a year ago

np. Out of curiousity, why tr rather than extra parameters to sed?

anubhava Over a year ago

@devnull: lol :) not intentionally. Somehow I thought sed is better for this but your grep is pretty kool one too.

|

Collectives™ on Stack Overflow

Linux shell script: How to match substring with regex

2 Answers 2

Comments

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related