|
|
Sponsored Content
Operating Systems
Linux
Fedora
Help with Unix commands
Post 302470680 by tina_2010 on Wednesday 10th of November 2010 08:22:14 PM
11-10-2010
Help with Unix commands
Hi, I have the following file called addresses, (it is a large file i have only copy and pasted few of the data below) and I am wanting to write a command so it will Find the ratio of mobile (07....) to land line (01....) telephone numbers?
then find the most popular first name and list the telephone numbers of everyone with that name.
sample data:
Richard:Richards:88 Birch Grove:01264290192
Jenny:Taylor:217 Victoria Place:07337349573
Jim:Jones:337 Wilmslow Road:07404751140
Richard:Richards:88 Birch Grove:01264290192
Jenny:Taylor:217 Victoria Place:07337349573
Jim:Jones:337 Wilmslow Road:07404751140
If anyone could help me, would be a great help, thank you
---------- Post updated at 08:22 PM ---------- Previous update was at 08:15 PM ----------
I have got this far with the first part of my question, but obv that out puts every entry individually and doesnt give me a ratio style output (eg.35:30)
this is what i got :
awk -F':' '{count[$4]++}END{for(j in count) print j ":" j, "("count[j]")"}' addresses
then find the most popular first name and list the telephone numbers of everyone with that name.
sample data:
Richard:Richards:88 Birch Grove:01264290192
Jenny:Taylor:217 Victoria Place:07337349573
Jim:Jones:337 Wilmslow Road:07404751140
Richard:Richards:88 Birch Grove:01264290192
Jenny:Taylor:217 Victoria Place:07337349573
Jim:Jones:337 Wilmslow Road:07404751140
If anyone could help me, would be a great help, thank you
---------- Post updated at 08:22 PM ---------- Previous update was at 08:15 PM ----------
I have got this far with the first part of my question, but obv that out puts every entry individually and doesnt give me a ratio style output (eg.35:30)
this is what i got :
awk -F':' '{count[$4]++}END{for(j in count) print j ":" j, "("count[j]")"}' addresses
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Where can I get a list of basic commands ? I want to get up to speed as soon as possible ? thanks..... (4 Replies)
Discussion started by: drukkie
4 Replies
2. UNIX for Dummies Questions & Answers
I want to know if there is a way to send unix commands thru FTP from a mainframe to kick off Autosys Jobs. I just need to send a command from the mainframe to UNIX and have UNIX execute that command. (2 Replies)
Discussion started by: skammer
2 Replies
3. UNIX for Dummies Questions & Answers
I would be happy to streamline some of the commands I am trying to learn with easy to remember terms, like dir for ls -l. I am wondering if you script certain commands for every time you start-up your system, can use those aliases there? If so, would that prove a problem for administrators who... (2 Replies)
Discussion started by: wmosley2
2 Replies
4. HP-UX
HP 9000/800 Server running HP-UX UNIX Server, users are connected via LAN and dialup connection.
Need help to write SHELL SCRIPT or UNIX Commands which would perform the following:
-ping IP address of all login/connected users to our server
-send customized text message to all the login... (1 Reply)
Discussion started by: Moinul Haque
1 Replies
5. UNIX Desktop Questions & Answers
What is the unix command that will display the current UTC time, hours, and minutes only.
What is the unix command for sorting in descending order.
What is the unix command for display the first 10 characters in a file. (4 Replies)
Discussion started by: charlton
4 Replies
6. UNIX for Dummies Questions & Answers
I am able to run the UNIX commands in a Windows box from a UNIX box through "SSH" functionality. But whenever the SSH connection is established between UNIX and Windows, password for windows box is being asked.
Is there a way to avoid asking password whenever the SSH connection is made? Can I... (1 Reply)
Discussion started by: D.kalpana
1 Replies
7. UNIX for Dummies Questions & Answers
i want to know how to do a few things using unix commands.
firstly say I have a .txt file that contains random lines like
Hello
Goodbye
I'm tired
5
74
using the grep command how can I get a list of lines that contain ONLY digits?
also using pipes to combine ls and grep commands how... (5 Replies)
Discussion started by: ez45
5 Replies
8. UNIX for Dummies Questions & Answers
Hello Folks
Where can I find all the unix commands with explanations , on the internet. I am searching but most of the sites are listing a few of the important ones. PLease guide through
thanks (4 Replies)
Discussion started by: supercops
4 Replies
9. UNIX for Dummies Questions & Answers
What are the various commands which use $ in unix and what do each of these indicate? eg: echo $? returns the success status of the previous commands..similarly $$ returns some numeric value..wat exactly are these?
From where can a download a document which can help me getting more details about... (2 Replies)
Discussion started by: DDS
2 Replies
10. UNIX for Dummies Questions & Answers
Having trouble doing the following things, I know it has something to do with using metacharacters but I'm not able to get it working correctly.
I need a command to get a long directory listing of all the files that have:
exactly two characters following the letters zot.
all files that... (1 Reply)
Discussion started by: lakers34kb
1 Replies
LEARN ABOUT CENTOS
grub-render-label
GRUB-RENDER-LABEL(1) User Commands GRUB-RENDER-LABEL(1) NAME
grub-render-label - generate a .disk_label for Apple Macs. SYNOPSIS
grub-render-label [OPTION...] [OPTIONS] DESCRIPTION
Render Apple .disk_label. -b, --bgcolor=COLOR use COLOR for background -c, --color=COLOR use COLOR for text -f, --font=FILE use FILE as font (PF2). -i, --input=FILE read text from FILE. -o, --output=FILE set output filename. Default is STDOUT -t, --text=STRING set the label to render -v, --verbose print verbose messages. -?, --help give this help list --usage give a short usage message -V, --version print program version Mandatory or optional arguments to long options are also mandatory or optional for any corresponding short options. REPORTING BUGS
Report bugs to <bug-grub@gnu.org>. SEE ALSO
The full documentation for grub-render-label is maintained as a Texinfo manual. If the info and grub-render-label programs are properly installed at your site, the command info grub-render-label should give you access to the complete manual. grub-render-label (GRUB) 2.02-2ubuntu8.3 July 2018 GRUB-RENDER-LABEL(1)