Extract column data from File

sudheshnaiyer · #1 (**permalink**) 10-11-2007

I have a file containing the lines similar to the following entries:

File1.txt:
.....
-rw-r--r-- 1 root staff 4110 Aug 7 17:02 XXX_OrderNum1_date1_time1.txt
-rw-r--r-- 1 root staff 4110 Aug 7 17:02 XXX_OrderNum2_date2_time1.txt
-rw-r--r-- 1 root staff 4110 Aug 7 17:02 XXX_OrderNum1_date2_time1.txt
....

My goal is to prepare a file which contains all the orders that occured more than once.

Like File2.txt:
OrderNum1 = 2 times

How can we achieve this?

zazzybob · #2 (**permalink**) 10-11-2007

Code:

$ awk '{print $NF}' tmp/file.txt | sed 's/^[^_]*_\([^_]*\)_.*$/\1/' | sort | uniq -c | awk '$1 !~ /^1$/ {printf( "%s = %s time(s)\n", $2, $1 )}'

Cheers,
ZB

ghostdog74 · #3 (**permalink**) 10-11-2007

Code:

awk 'BEGIN{FS="_"}{a[$2]++}
     END{for (i in a) print i " : " a[i]}' "file"

Ygor · #4 (**permalink**) 10-11-2007

Just the duplicates...

Code:

cut -d _ -f2 file1.txt | sort | uniq -d

Duplicates with count...

Code:

cut -d _ -f2 file1.txt | sort | uniq -c | awk '$1>1&&$0=$2 " = " $1 " times"'

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to extract only first column from the file	selamba_warrior	Shell Programming and Scripting	11	05-21-2008 02:52 AM
I need to extract last column of a file and compare the values	vukkusila	Shell Programming and Scripting	4	08-04-2007 11:21 AM
Better way to Validate column data in file.	barry1	Shell Programming and Scripting	12	12-19-2006 05:23 PM
Extract data from file	getdpg	Shell Programming and Scripting	20	08-03-2006 03:54 AM
extract data from file	apalex	Shell Programming and Scripting	2	04-27-2002 01:24 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