Retrieve line from a file based on a value in specific column

efernandes · #1 (**permalink**) 01-27-2007

Hi,

I have a file that has several values seperated by ":"

Code:

2006:John:Student:Football:Portugal:Cinema
2006:James:Engineer:Basket:Poland:Theatre
2007:Lucy:Diver:Gymnastic:England:Music
2007:Smith:Plumber:Basket:Spain:Poker

I need make a filter based on the 5th field to find countries that start with a pecific character and then retrieve the lines that match this filter.

Exemple: Find countries starting with 'P'

Result:
2006:John:Student:Football:Portugal:Cinema
2006:James:Engineer:Basket:Poland:Theatre

Thanks
Elio

ghostdog74 · #2 (**permalink**) 01-27-2007

One way using awk:

Code:

awk -F":" '$5 ~ /^P/{print    }' file

Using Python as an alternative:

Code:

#!/usr/bin/python
for line in open("file"):
    if line.split(":")[4].startswith("P"):
        print line.strip()

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Splitting av file in 2 at specific place based on textpattern	borgeh	Shell Programming and Scripting	0	09-24-2007 07:02 PM
How to retrieve a particular line from a file	vinayap	UNIX for Dummies Questions & Answers	2	07-11-2007 02:16 PM
search and retrieve previous line in file	paulsew	Shell Programming and Scripting	2	02-23-2007 08:04 AM
how do we retrieve a line from a file in unix	lmadhuri	Shell Programming and Scripting	2	02-07-2007 08:07 AM
(cont) Retrieve line from a file based on a value in specific column	efernandes	UNIX for Dummies Questions & Answers	0	01-27-2007 01:00 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by