UNIX for Dummies Questions & Answers

Hello,

I have a log file that outputs the data below. I would like to grep and display the data where column is equal '148.'

I've searched the forum, and couldn't find any answers.
I've tried all the grep switches and I get the same result as the log.
I'm thinking I might have to use an if statement and grep; I'm working on a "one-liner" and it's taking me some time. Please help!

log
XJLGZ|380377|2|148|4|1500000|040|21|5|
LGCZL|380696|2|148|3|1500000|100|23|5|
XJLMW|314873|2|20|2|1500000|040|21|5|
XTQCW|381585|2|148|4|1500000|300|12|5|
Z6B65|741481|2|18|4|81500000|310|2|1|

Desired Output
XJLGZ|380377|2|148|4|1500000|040|21|5|
LGCZL|380696|2|148|3|1500000|100|23|5|
TQCW|381585|2|148|4|1500000|300|12|5|

Hi, here are a couple of options

Code:

awk -F'|' '$4==148' infile

Code:

grep '^\([^|]*|\)\{3\}148|' infile

Code:

sed -n '/^\([^|]*|\)\{3\}148|/p' infile

Thank you very much! That was simple.

---------- Post updated at 01:31 PM ---------- Previous update was at 01:24 PM ----------

The code below should allow me to display just column 1, correct?
Could I also display and save to a file using tee? I'll give it try.

Code:

awk -F'|' '$4 == 148' infile |awk '{print ($1)}'

Thanks for your help!

---------- Post updated at 01:33 PM ---------- Previous update was at 01:31 PM ----------

Oops wasn't paying attention to the first AWK! I'll have to try something different.

It should work if you use the same field separator in the second awk. But you do not require a pipe:

Code:

awk -F'|' '$4==148{print $1}' infile

Code:

cut -d "|" -f 1  desired_infile

---------- Post updated at 02:54 PM ---------- Previous update was at 02:18 PM ----------

Excellent, this work absolutely perfect! I can now tee the data

Thanks for your help Scrutinizer! I'll be testing those examples you sent, just so I become more familiar. LOL! I'm a noob as you can tell!

Code:

awk -F'|' '$5==148 {print $1}' infile