Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Using the Sort, Cut, and Awk commands
Top Forums UNIX for Dummies Questions & Answers Using the Sort, Cut, and Awk commands Post 302258716 by rubin on Saturday 15th of November 2008 01:18:01 PM
Old 11-15-2008
Quote:
Originally Posted by babbabooey
...
Bill Adams: ABC Contracting: 11-14-07: 6919408:314-463-2219
Bill Adams: ABC Contracting: 2-22-07: 4109663:314-463-2219
Bill Adams: ABC Contracting: 11-6-07: 6918997:314-463-2219
Steve Leitch: ERB Equipment: 11-6-07: 6918967:314-225-6403

There are thousands of records and I only want the ones from 11-07 and I only want the name and company of the contractor to be displayed once in my output.

Thanks again.
Assuming the same file formation as the one shown above, and filtering is done based on the contractor's name, you can try:

Code:
  awk -F: '$3 ~ /11-[0-3]?[0-9]-07/ && !a[$1]++ { print $1, $2 > "Nov_2007" }' file

Code:
$  cat Nov_2007
Bill Adams  ABC Contracting
Steve Leitch  ERB Equipment

For a fancier output use printf.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Need Help with Awd/sort commands

Can anyone give me a hand with some questions by e-mailing me directly, so I can relay the questions inorder. I really would appreciate anyone that can help. Thank You in advance, I am online and will reply instantly. Charley <email removed> (5 Replies)
Discussion started by: flarebel
5 Replies

2. UNIX for Dummies Questions & Answers

Help with Last,uniq, sort and cut

Using the last, uniq, sort and cut commands, determine how many times the different users have logged in. I know how to use the last command and cut command... i came up with last | cut -f1 -d" " | uniq i dont know if this is right, can someone please help me... thanks (1 Reply)
Discussion started by: jay1228
1 Replies

3. Shell Programming and Scripting

using cut command with sort

how to cut for pattern in the file and then count each occurance? say, each line has unique pattern and u want to grep but at last, you want to see how many of them occur? say, cut -d'\" -f15 filename | sort -? or.. do i need to use sed or something.. i need to count lets say how... (5 Replies)
Discussion started by: hankooknara
5 Replies

4. Shell Programming and Scripting

sort / cut question

Hi All, I have a small problem, hope you can help me out here. I have a file that contains the same format of lines in 99% of the cases. 906516 XYZ.NNN V 0000 20070711164648 userID1 userID2 hostname 20070711164641 There are unfortunately several lines with these... (5 Replies)
Discussion started by: BearCheese
5 Replies

5. Solaris

concatenate/sort/cut

I have the following requirement. 1. I have to concatenate the 10 fixed width files. 2. sort based on first 10 characters 3. after that i have remove first 10 chacters from the file. can you please tell me how to do it. Thanks in Advance Samba (1 Reply)
Discussion started by: samba
1 Replies

6. Homework & Coursework Questions

Help with cut and sort

<B>andan100:Anders:Andersson:800101-1234:TNCCC_1:TDDB46 TDDB80:berbe101:Bertil:Bertilsson:800102-1234:TNCCC_1:TDDB46 TDDB80:The top is how it looks right now I want it t look like this under and I want it to be sorted. I have tried with cut -f -d studenter.txt and so on but it still doesnt work... (2 Replies)
Discussion started by: aannaann
2 Replies

7. Shell Programming and Scripting

Using a combination of sort/cut/grep/awk/join/paste/sed

I have a file and need to only select users that have a shell of “/bin/bash” in the line using awk or sed please help (4 Replies)
Discussion started by: boyboy1212
4 Replies

8. UNIX for Advanced & Expert Users

cut and sort

Please help. I have a file containing rows of information. The row needs to be broken down into blocks of 5 and then sorted. Example: 10381 1042010046 ... (4 Replies)
Discussion started by: Dolph
4 Replies

9. Shell Programming and Scripting

How to combing output of cut commands with a delimiter?

While looping through a file, I am cutting different length of characters (based on their length) like columns and want to produce the output in a separate file with different columns being separated by a comma. How to achieve this with an online command. I don't want to create multiple variables... (8 Replies)
Discussion started by: mady135
8 Replies

10. Shell Programming and Scripting

Sending output of program into subsequent commands (i.e. awk/sort)

Hi, I have identified how to use command chaining as per below on a file, to capture the header of a file, as well as the line containing the C: drive. $ cat test.txt Filesystem Size Used Avail Use% Mounted on rootfs 237G 153G 84G 65% / none 237G 153G 84G ... (6 Replies)
Discussion started by: sand1234
6 Replies

LEARN ABOUT DEBIAN

scottfree

ScottFree(6)							   Games Manual 						      ScottFree(6)

NAME

       scottfree -- interpreter for Scott Adams database game files

SYNOPSIS

       scottfree [-d]  [-i]  [-y]  [-s]  [-t]  [databasename]  [save-file]

DESCRIPTION

       This manual page documents briefly the scottfree command.

       This  manual  page was written for the Debian distribution because the original program does not have a manual page.  Instead, it has docu-
       mentation in text format; see below.

       scottfree is a program that reads and executes TRS80 format Scott Adams datafiles.

OPTIONS

       -d	 Debugging info on load.

       -i	 Generate "I am"-style messages. (default)

       -y	 Generate "You are"-style messages.

       -s	 Generate authentic Scott Adams driver light messages rather than other driver style ones.

       -t	 Generate TRS80 style display.

SEE ALSO

       /usr/share/doc/scottfree/

AUTHOR

       This manual page was written by Clint Adams <schizo@debian.org> for the Debian system (but may be used by others).  Permission  is  granted
       to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or any later version published
       by the Free Software Foundation.

																      ScottFree(6)
All times are GMT -4. The time now is 02:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy