Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: help with awk to create report
Top Forums Shell Programming and Scripting help with awk to create report Post 59928 by ghazi on Tuesday 4th of January 2005 11:19:09 PM
Old 01-05-2005
help with awk to create report
Hi,

I am trying to create a report using the following syntax:

#!/bin/awk -f
#script name: users_report
BEGIN { FS=":" ; OFS="\t" ; print "User\tGID\tUser Name\tHome Dir\t"
{ print $1 , $3 , $5 , $6 }
END { print "\n End of Report \n" }

$> user_report /etc/passwd

the output of above code is as under:
User GID User Name Home Dir
jbond 500 James Bond /home/sales
pdavid 501 Pierre Davidd /home/Marketing
... so on
END of Report

now trying to change the GID number to group name from /etc/group first filed.

the output should look like this:

User GID User Name Home Dir
jbond SALES James Bond /home/sales
pdavid Market Pierre Davidd /home/Market
... so on
END of Report

Can someone help me complet this code with awk or with any other appropriate command syntax please.

Thanks in advance for your help.

Regards,
Ghazi
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create a report using shell

hi suppose I want to create a report where it will shows the machine name, the date & time when the report is produced. can anyone please help me to write such shell script? requesting all. Thanks (10 Replies)
Discussion started by: moco
10 Replies

2. Shell Programming and Scripting

using todays date to create a report using grep

What i'm trying to do is to use grep to search through a few files for a selected daemon and only report on today's date. I think I got it sorted apart from in the txt file the date has 2 gaps between the month and the day, and the way I have the date format only puts in one gap any help to get... (3 Replies)
Discussion started by: MBN
3 Replies

3. Shell Programming and Scripting

How to format or create a matrix report from file

Dear Unix champs, I have a input file as attached, i would like to create an report from the file as below FileType | EQUENS0001 | EQUENS0002 | EQUENS1100 | EQUENS0003 --------+-------------------------------------------------------- Msg No |... (3 Replies)
Discussion started by: manas_ranjan
3 Replies

4. Shell Programming and Scripting

Bash: create a report with grep output?

Greetings. I need to generate a simple report via Bash (Korn?) with this raw data Test_Version=V2.5.2 Test_Version=V2.6.3 Test_Version=V2.4.7 Test_Version=V2.5.2 Test_Version=V2.5.2 Test_Version=V2.5.1 Test_Version=V2.5.0 Test_Version=V2.3.9 ... (3 Replies)
Discussion started by: alan
3 Replies

5. Shell Programming and Scripting

Need to develop a script to create a report reading multiple server logs

I am currently trying to develop a script to connect to mulltiple servers, reading specifc data from log files on the servers and append the data from each file into a single tab delimited row. So, at the end I am planning to have a report with all the extracted data with each row per server. I am... (5 Replies)
Discussion started by: scriptingnewbie
5 Replies

6. Shell Programming and Scripting

Create a report for client with a text data file

Hi, I am an amateur bash scriptwriter and I need to write a script which creates a report in a formatted, easy to read table-like that is displayed to standard output. The script has to export the followings: Process ID,User Name, Command Name,Priority..... Now I have a file that I can see all... (3 Replies)
Discussion started by: bashily
3 Replies

7. Shell Programming and Scripting

Script to create DHCP report

Hi, In our company, we have been asked to design a script to automate the report of all IP's which are free/used from all the pools in DHCP at any given Amount of time. We have prepare the following script. The problem is when we run the script manually from the command prompt, it brings proper... (1 Reply)
Discussion started by: Crazy_Nix
1 Replies

8. Shell Programming and Scripting

awk to create variables to pass into a bash loop to create a download link

I have created one file that contains all the necessary info in it to create a download link. In each of the lines /results/analysis/output/Home/Auto_user_S5-00580-6-Medexome_67_032/plugin_out/FileExporter_out.67... (8 Replies)
Discussion started by: cmccabe
8 Replies

9. Shell Programming and Scripting

Need to create a report using paste or with awk

Input file will be Name: serve1 has disk :Yes dev (8): Name: serve2 has disk :No dev (8): Name: serve3 has disk :No Name: serve4 has disk :Yes dev (8): Need output like that. I was using pate -d, - - - . But that need all the line in same format in this some server it has... (4 Replies)
Discussion started by: ranjancom2000
4 Replies

LEARN ABOUT DEBIAN

finance::quote::tiaacref

Finance::Quote::Tiaacref(3pm)				User Contributed Perl Documentation			     Finance::Quote::Tiaacref(3pm)

NAME

       Finance::Quote::Tiaacref - Obtain quote from TIAA-CREF.

SYNOPSIS

	   use Finance::Quote;

	   $q = Finance::Quote->new;

	   %stockinfo = $q->fetch("tiaacref","TIAAreal");

DESCRIPTION

       This module obtains information about TIAA-CREF managed funds.

       The following symbols can be used:

	   Stock:			       CREFstok
	   Money Market:		       CREFmony
	   Equity Index:		       CREFequi
	   Inf-Linked Bond:		       CREFinfb
	   Bond Market: 		       CREFbond
	   Social Choice:		       CREFsoci
	   Global Equities:		       CREFglob
	   Growth:			       CREFgrow
	   TIAA Real Estate:		       TIAAreal

	   PA Stock Index:		       TIAAsndx
	   PA Select Stock:		       TLSIX
	   PA Select Growth Equity:	       TLGEX
	   PA Select Growth Income:	       TLGIX
	   PA Select Int'l Equity:	       TLIEX
	   PA Select Social Choice:	       TLSCX
	   PA Select Large Cap Value:	       TLLCX
	   PA Select Small Cap Equity:	       TLCEX
	   PA Select Real Estate:	       TLREX

	   TIAA-CREF Money Market:	       TIAXX
	   TIAA-CREF Bond Plus: 	       TIPBX
	   TIAA-CREF High-Yield Bond:	       TCHYX
	   TIAA-CREF Inflation-Linked Bond:    TCILX
	   TIAA-CREF Short-Term Bond:	       TCSTX
	   TIAA-CREF Tax-Exempt Bond:	       TCTEX
	   TIAA-CREF Real Estate Securities:   TCREX
	   TIAA-CREF Equity Index:	       TCEIX
	   TIAA-CREF Growth Equity:	       TIGEX
	   TIAA-CREF Growth & Income:	       TIGIX
	   TIAA-CREF International Equity:     TIINX
	   TIAA-CREF Large-Cap Value:	       TCLCX
	   TIAA-CREF Mid-Cap Growth:	       TCMGX
	   TIAA-CREF Mid-Cap Value:	       TCMVX
	   TIAA-CREF Small-Cap Equity:	       TCSEX
	   TIAA-CREF Social Choice Equity:     TCSCX
	   TIAA-CREF Managed Allocation:       TIMAX

       This module is loaded by default on a Finance::Quote object.  It's also possible to load it explicitly by passing "Tiaacref" in to the
       argument argument list of Finance::Quote->new().

       Information returned by this module is governed by TIAA-CREF's terms and conditions.

LABELS RETURNED

       The following labels may be returned by Finance::Quote::Tiaacref: symbol, exchange, name, date, nav, price.

SEE ALSO

       TIAA-CREF, http://www.tiaa-cref.org/

perl v5.14.2							    2012-05-06					     Finance::Quote::Tiaacref(3pm)
All times are GMT -4. The time now is 02:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy