How to grep column after second pipe

Question

Example:

3|100|test@test.com|0|0|6:1,10,11,12,13,2,3,4,5,6,9|7:1,10,11,13,16,2,4,5,6,9|

Expected view after grep:

test@test.com

Answer 1

Use cut:

$ echo '3|100|test@test.com|0|0|6:1,10,11,12,13,2,3,4,5,6,9|7:1,10,11,13,16,2,4,5,6,9|' |\
cut -d'|' -f3
test@test.com

Answer 2

Why grep? Use cut

echo "3|100|test@test.com|0|0|6:1,10,11,12,13,2,3,4,5,6,9|7:1,10,11,13,16,2,4,5,6,9|" | cut -d '|' -f 3

Answer 3

Maybe awk is better suited for this usage:

awk 'BEGIN { FS = "|" } ; { print $3 }'

If you have to extract more than one field from such an input, I think it is the easiest using awk.

(OFF: excuse me if I pointed in an awk-ward direction)

Answer 4

Just Imagine your content is present under this file file1

[max@localhost ~]$ cat file1 3|100|test@test.com|0|0|6:1,10,11,12,13,2,3,4,5,6,9|7:1,10,11,13,16,2,4,5,6,9|

To cut the third field use this command

[max@localhost ~]$ cut -d "|" -f3 file1

test@test.com

Here

-d : Specifies to use character | as delimiter

-f1 : Print first field, if you want print second field use -f2, third field use -f3, and so on...

suppose file1 content is like this

[max@localhost ~]$ cat file1

root:x:0:0:root:/root:/bin/bash

Then we have to use : as delimiter like this

To cut first field use f1

[max@localhost ~]$ cut -d ":" -f1 file1
root

To cut second field use f2

[max@localhost ~]$ cut -d ":" -f2 file1
x

To cut third field use f3

[max@localhost ~]$ cut -d ":" -f3 file1
0

Answer 5

Just for fun, here's how you could do it with grep and tr:

<infile grep -Eo '^([^|]+\|){3}' | grep -Eo '[^|]+\|$' | tr -d '|'

The first regex grabs the first three pipe delimited fields. The second grep picks out the last field and tr removes the remaining delimiter.