Sponsored Content
Top Forums Shell Programming and Scripting Question about formatting output using AWK Post 302213236 by Fatbob on Wednesday 9th of July 2008 03:39:45 PM
Old 07-09-2008
Thanks for your help shamrock. Your script worked fine.

However my file has changed to the following...

Code:
0=Administrator
5000001=user1
5000002=user2
5000003=user3
5000006=user4
5000007=user5
5000219=user6
11000156=user7
11003130=user8
11003132=user9

so when I rec = $0 to rec = $1 I loose the first row. This is what I get...

5000001, 5000002, 5000003, 5000006, 5000007, 5000219, 11000156, 11003130, 11003132

Why am I loosing the first row?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Question about formatting the output

I need to ask a question on how to format the output in a csv format. Right now i am running a shell script which executes a command and the following output is append through a unix script in a .csv file. So the output of xyz.csv is as follow :- 1. Number = 25 Amount $84,132.22 2.... (1 Reply)
Discussion started by: chris1234
1 Replies

2. Shell Programming and Scripting

formatting the output

Is it possible to convert the attached file to the format mentioned. Here for a particular job the table name and the corresponding instance name from one test run "X" is compared with the table name and the instance name from the second test run "Y" for output rows,affected rows,applied... (1 Reply)
Discussion started by: ragavhere
1 Replies

3. Shell Programming and Scripting

formatting output

my script is as follows cnt=`ps -ef |grep pmon|grep -v grep|awk 'END {{print NR}}'` cnt2=`ps -ef |grep tns|grep -v grep|awk 'END {{print NR}}'` if then if then rman target/ catalog recdb/recdb@recdb cmdfile report_need_backup.sql > report_need_backup.txt ... (1 Reply)
Discussion started by: swkambli
1 Replies

4. Shell Programming and Scripting

output formatting with awk.

# echo $PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin How would i write a script to display permission on each folders in $PATH variable below format. drwxr-xr-x 2 0 root 4096 Nov 24 14:51 /usr/kerberos/sbin drwxr-xr-x 2 0... (2 Replies)
Discussion started by: pinga123
2 Replies

5. Shell Programming and Scripting

Formatting of output from awk

Hi; i m running an command like; getfacl $(find /home/fstl/testShell/ -type f -ls | awk '{print $11}') and i m getting outpiut for all files in "testShell" folder as; # file: home/fstl/testShell/.script1.sh.swp # owner: root # group: root user:fstl:rw- user:ajay:rw- group:root:r--... (1 Reply)
Discussion started by: ajaypadvi
1 Replies

6. Shell Programming and Scripting

awk question : system output to awk variable.

Hi Experts, I am trying to get system output to capture inside awk , but not working: Please advise if this is possible : I am trying something like this but not working, the output is coming wrong: echo "" | awk '{d=system ("date") ; print "Current date is:" , d }' Thanks, (5 Replies)
Discussion started by: rveri
5 Replies

7. Shell Programming and Scripting

Formatting grep and awk output

Hi there. I have a very large file and I am trying to format it so that I can pull out certain pieces of data/info and report it in spreadsheet format/style. The file has ###### which will separate each line that will be listed in the spreadsheet. Whenever I find "No" at the end of a line I want... (7 Replies)
Discussion started by: kieranfoley
7 Replies

8. Shell Programming and Scripting

Formatting output using awk in ksh

:oi was trying to write a script to format output of a command in ksh which has output as below: so i used : to get which i require at all times. But problem occurs when status part changes. above output i get when status is SU (success).If the status is IN (inactive), output of... (1 Reply)
Discussion started by: pr5439
1 Replies

9. Shell Programming and Scripting

awk Script Output in Outlook Formatting Issue

When i execute the below shell script with 2 different Input files, for one of the data files (datafile1) my email message body in the outlook messes up and every thing comes up in one line. May i please know what i am doing wrong here or how to fix this? The only difference in data files is one is... (1 Reply)
Discussion started by: Ariean
1 Replies

10. Shell Programming and Scripting

Problem in formatting output in sed / awk

I have a file like this : ! 1 ! 542255 ! 50,140.00 ! ! 2 ! 551717 ! 5,805.00 ! ! 3 ! 551763 ! 8,130.00 ! ! 4 ! 551779 ! 750.00 ! ! 5 ! 551810 ! 56,580.00 ! ! 6 ! 551816 ! 1,350.00 ! ! 7 ! 551876 ! 360.00 ! ! 8 ! 551898 ! ... (10 Replies)
Discussion started by: adam1969in
10 Replies
play(1) 						      General Commands Manual							   play(1)

NAME
play - play any sound file to audio device rec - record audio to any sound file format SYNOPSIS
play [fopts] infile [effect] rec [fopts] outfile [effect] DESCRIPTION
This manual page briefly documents the play and rec commands. play and rec are programs that allow you to play and record different types of sound files from the command line. They are front ends to the more general sox(1) package. Normally, the play command will automatically detect the type and other parameters of the soundfile. If it can't do so, the parameters can be changed through options. OPTIONS
A summary of common options are included below. For a complete description of options and their values, see the sox(1) man page. -c [channels], --channels=[channels] Define the number of channels in the file. -d [device], --device=[device] Specify a different device to play the sound file to. -f [format], --format=[format] Specify bit format of the sample. One of s, u, U, A, a, or g. -r [rate], --rate=[rate] Specify the sample rate of the audio data (samples per second). -s [size], --size=[size] Specify the width of each sample. One of b, w, l, f, d, or D. -t [type], --type=[type] Specify audio file format to use. Useful if it can not be automatically determined. -v [volume], --volume=[volume] Change the audio volume -x , --xinu Reverse the byte order of the sample (only works with 16 and 32-bit data). -h, --help Show summary of options. --version Show version of play/rec. Description of effects are described in the sox(1) man page. SEE ALSO
sox(1) soxexam(1) AUTHOR
This manual page was written by Guenter Geiger <geiger@iem.mhsg.ac.at>, for the Debian GNU/Linux system. Updates by Anonymous. December 11, 2001 play(1)
All times are GMT -4. The time now is 08:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy