UNIX for Dummies Questions & Answers

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?

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

Code:

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

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"'