Sponsored Content
Full Discussion: Output formatting
Top Forums Shell Programming and Scripting Output formatting Post 302495673 by vakharia Mahesh on Thursday 10th of February 2011 11:11:41 PM
Old 02-11-2011
Output formatting

I have input file in this way


Code:
John   1234   BASIC       26000 
John   1234   ALLOWC      01550
John   1234   INCER       01700
John   1234   REL         20000
Debi   2345   BASIC       29000
Debi   2345   ALLOWC      01600
Debi   2345   INCR        01900
Debi   2345   REL         21000
Rob    3456   BASIC       15000
Rob    3456   REL         01500

The output require is in the fowllowing format
Code:
Name   EMP     BASIC     ALLOWC     INCER     REL
John    1234   26000     01550      01700      20000
Debi    2345   29000     01600      01900      21000
Rob     3456   15000      --         --        01500

Here some employee may have joined newly so may not get all the perq.
That thas to be left blank .
Had it been equal numbers of lines for each employee then we can use the command paste .

Thanks in advance
Vakharia M JSmilie
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Formatting the output

Hi all, Have the following code(1) producing the results(2 & 3). Would like to know if there is a way to format the two reports created in a similar fashion. IE - The first is formatted nicely as a result of the echo "$xmpbdate $xavgs" >> $xmpbrpt However when I attempt to do the same on... (7 Replies)
Discussion started by: Cameron
7 Replies

2. Shell Programming and Scripting

formatting output

Hi need some advice.. #grep -i hostname test.csv (gives the below output) HOSTNAME,name,host_test,,,,,,,, Now I need to format the above output as below. HOSTNAME: name=host_test Any easy way of doing this using awk or sed or printf? (4 Replies)
Discussion started by: balaji_prk
4 Replies

3. Shell Programming and Scripting

Formatting Output

Hi I tried running the below awk 'BEGIN { printf ("%s %-51s %s %-7s %s",$var1,$var2,$var3,$var4,$var5)}' from the command prompt and it is not working. Getting the error awk: Field $() is not correct. The source line number is 1. Actually my requirement is to form a string based on... (6 Replies)
Discussion started by: dhanamurthy
6 Replies

4. Shell Programming and Scripting

more help with formatting ls output...

Ok, for a fun project, my goal is to replicate the style of "catalog" on an old apple ] *A 002 SOMEAPPLESOFTFILE B 004 SOMEFILE T 006 SOMETEXT I 002 SOMEINTEGERFILE The first character is either " " or "*" depending on if the file is locked or not. Next is the filetype, so in... (1 Reply)
Discussion started by: patrick99e99
1 Replies

5. Shell Programming and Scripting

Formatting ls output

I am using find and ls to search for "warez" files on my server. find /home/ -regex ".*\.\(avi\|mp3\|mpeg\|mpg\|iso\)" -print0 | xargs -0 ls -oh This command produces this: -rw-r--r-- 1 1000 3.2M Feb 18 2009 /home/user/public_html/lupus.mp3 I want to only get this 3.2M... (4 Replies)
Discussion started by: bonrad
4 Replies

6. Shell Programming and Scripting

formatting output

Sorry for being a n00b, but I'm having a lot more trouble than I should with formatting the output to the program I finally completed. I'm basically looking for the linux equivalent to setw( ) from c++ so that I can print things in columns like this (but without the underlines lol): MISSPELLED: ... (4 Replies)
Discussion started by: aikaterinimak
4 Replies

7. Shell Programming and Scripting

Formatting of output

Hi Experts, I have to create a report for certain audit and my output looks as follows I m trying to format my output to look like Any inputs would be highly appreciated Thanks Syed (5 Replies)
Discussion started by: maverick_here
5 Replies

8. Shell Programming and Scripting

Output Formatting

Hi Guys I need help removing some lines from output i am receiving from a shell script. Here is the output: http://i52.tinypic.com/10z0fut.png I am trying to remove the output that i have circled. . ${EDW}/extracts/bin/extracts_setup2.sh . ${EDW}/extracts/extracts.conf ... (7 Replies)
Discussion started by: mooey1232003
7 Replies

9. Shell Programming and Scripting

Formatting the output

Hi, I have a file which contents entries in this form. Only in /data4/temp abc.000001 Only in /data4/temp abc.000003 Only in /data4/temp abc.000012 Only in /data4/temp abc.000120 Only in /data4/temp abc.000133 Only in /data4/temp abc.001444 i want to read line by line and format... (2 Replies)
Discussion started by: arijitsaha
2 Replies

10. Shell Programming and Scripting

Formatting the Output

Hi, I am trying to use printf command and format certain output in a specific format as under: While the left side (upto |) of the above format is part of a fixed header function, the right side is where i am expecting data to be printed. However, as seen, Row1 value is reflecting on last... (5 Replies)
Discussion started by: EmbedUX
5 Replies
ISDNCONF(1)						      Linux System Utilities						       ISDNCONF(1)

NAME
isdnconf - manipulate or read ISDN phone number config files. SYNOPSIS
isdnconf DESCRIPTION
isdnconf can manipulate or read the file /etc/isdn/callerid.conf as well as ~/.isdn. Entries can be added or removed from these files. Additionally, entries can be searched for and displayed in a way similar to grep. An entry can be an own MSN ([MSN]) or a phone number ([NUMBER]). You can use this program to build your own phonebook. These files are used by many of the other ISDN utilities that use phone numbers, to display a number symbolicly instead of as a plain number. OPTIONS
Note: usage of the options -A and -D is dangerous! The complete structure of the file may be changed, and all comments are removed! Make backups of your data files before trying these. COMMAND OPTIONS: -A Add a new entry, which is read from standard input. The following values are asked for (here with examples): Alias: Fred Number: 0815/441777 SI: 0 Zone: 4 Interface: - Flags: I|O Program: /usr/local/bin/ring User: uucp Group: user Interval: Time: 8-20 Flags: (control-D here indicates end of flags) Alias: (control-D here indicated end of entries) If you want another [Flags] entry, simply enter the data for another program for this number at the point where the control-D was given above. If you want to add another number, simply enter the data for the next number at the Alias prompt. You can also pipe the data into this program; the input data then must correspond to the prompts that the program gives! Note that you can only add one number at a time then (there's no way of telling isdnconf that you want to stop giving Flags info and start giving the next Alias info). -D Delete one or more entries which match the data options given. How to supply the data to match is discussed below (see DATA OPTIONS). -V version: display the program's version and terminate. If both -A and -D are given together, isdnconf will terminate, as this is not a valid combination. If neither -A nor -D is given, then isdnconf will display entries which match the data given. DATA OPTIONS: (none applicable for -A) -n 'number' number: match the given number. It can contain wildcards. -a 'alias' alias: match the given alias name. The name can contain wildcards. Note: due to a bug, use '?' instead of '-'. -t 'SI' SI: match the given service indicator. -c 'code' code: match the area code of the phone number. Only usable for displaying (not for -A nor -D). -i ignore case for the -n and -a options. -w word: the parameters for -n and -a must match the whole value, not just a substring. Examples (here for -n): "*34*" matches 123456, 345677, 1234 "34*" matches 34567, 34111 but not 1234 "34??" matches 3411, 3456 "34" matches only 34 Without the -w option, these would match: "*34*" matches 123456, 345677, 1234 "34*" matches 123456, 345677, 1234, 34567, 34111 "34??" matches 123456, 345677, 1234, 3411, 3456 "34" matches 123456, 345677, 1234, 3411, 3456, 34567 -d and: by default the values given to options -n, -a and -t will be combined with a logical OR. If these should be combined with a logi- cal AND (which is probably what most people expect!) you must use this -d option. In this case you can only supply each of the -n, -a and -t options exactly once. OTHER OPTIONS: -q quiet: when using the -A or -D commands, the output is suppressed. When not using the -A or -D commands, only the alias of the match- ing number is shown, or just the number in case the alias is not found. -m MSN: when used in combination with the -A command, instructs isdnconf to create a new MSN entry; the default is to create a new NUMBER entry. Only the values alias, number, SI, zone and interface are applicable to an MSN entry. The following two options do not apply to the -A and -D commands. They only change the output format. -s short: only display the alias and the number. -l long: also display the programs to run ([START]). -f 'filename' file: usually isdnconf uses the /etc/isdn/callerid.conf and the ~/.isdn files. If isdnconf should be applied to another file, use this option. -g global: only applies to the -A and -D commands. Instead of editing ~/.isdn, /etc/isdn/callerid.conf is edited. -1 first: only delete or display the first entry. -M isdnmon: used internally by isdnmon to get alias info. AUTHOR
Andreas Kool <akool@isdn4linux.de> manpage adapted from the README by Paul Slootman <paul@isdn4linux.de> SEE ALSO
callerid.conf(5), isdnlog(8) isdn4k-utils-3.13 1998/12/29 ISDNCONF(1)
All times are GMT -4. The time now is 02:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy