Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Question about formatting output using AWK
Top Forums Shell Programming and Scripting Question about formatting output using AWK Post 302213249 by shamrock on Wednesday 9th of July 2008 04:23:52 PM
Old 07-09-2008
Quote:
Originally Posted by Fatbob
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?
That's because when variable rec is zero the if statement evaluates to false and the printf() is skipped. Change it instead to test if the string is null.

Code:
awk '{
    if (rec"")
       printf("%s, ", rec)
    rec = $1
} END {
    print rec
}' file

 

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

LEARN ABOUT DEBIAN

smpteframe

SMPTEFrame(3)							    libltcsmpte 						     SMPTEFrame(3)

NAME

       SMPTEFrame -

       Raw 80 bit SMPTE frame.

SYNOPSIS

       #include <ltcsmpte.h>

   Data Fields
       unsigned int frameUnits:4
       unsigned int user1:4
       unsigned int frameTens:2
       unsigned int dfbit:1
       unsigned int colFrm:1
       unsigned int user2:4
       unsigned int secsUnits:4
       unsigned int user3:4
       unsigned int secsTens:3
       unsigned int biphaseMarkPhaseCorrection:1
       unsigned int user4:4
       unsigned int minsUnits:4
       unsigned int user5:4
       unsigned int minsTens:3
       unsigned int binaryGroupFlagBit1:1
       unsigned int user6:4
       unsigned int hoursUnits:4
       unsigned int user7:4
       unsigned int hoursTens:2
       unsigned int reserved:1
       unsigned int binaryGroupFlagBit2:1
       unsigned int user8:4
       unsigned int syncWord:16

Detailed Description
       Raw 80 bit SMPTE frame.

       Definition at line 140 of file ltcsmpte.h.

Field Documentation
   unsigned int SMPTEFrame::binaryGroupFlagBit1
       Definition at line 160 of file ltcsmpte.h.

   unsigned int SMPTEFrame::binaryGroupFlagBit2
       Definition at line 168 of file ltcsmpte.h.

   unsigned int SMPTEFrame::biphaseMarkPhaseCorrection
       Definition at line 153 of file ltcsmpte.h.

   unsigned int SMPTEFrame::colFrm
       Definition at line 146 of file ltcsmpte.h.

   unsigned int SMPTEFrame::dfbit
       Examples:
	   tests/decoder.c.

       Definition at line 145 of file ltcsmpte.h.

   unsigned int SMPTEFrame::frameTens
       Definition at line 144 of file ltcsmpte.h.

   unsigned int SMPTEFrame::frameUnits
       Definition at line 141 of file ltcsmpte.h.

   unsigned int SMPTEFrame::hoursTens
       Definition at line 166 of file ltcsmpte.h.

   unsigned int SMPTEFrame::hoursUnits
       Definition at line 163 of file ltcsmpte.h.

   unsigned int SMPTEFrame::minsTens
       Definition at line 159 of file ltcsmpte.h.

   unsigned int SMPTEFrame::minsUnits
       Definition at line 156 of file ltcsmpte.h.

   unsigned int SMPTEFrame::reserved
       Definition at line 167 of file ltcsmpte.h.

   unsigned int SMPTEFrame::secsTens
       Definition at line 152 of file ltcsmpte.h.

   unsigned int SMPTEFrame::secsUnits
       Definition at line 149 of file ltcsmpte.h.

   unsigned int SMPTEFrame::syncWord
       Definition at line 171 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user1
       Definition at line 142 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user2
       Definition at line 147 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user3
       Definition at line 150 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user4
       Definition at line 154 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user5
       Definition at line 157 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user6
       Definition at line 161 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user7
       Definition at line 164 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user8
       Definition at line 169 of file ltcsmpte.h.

Author
       Generated automatically by Doxygen for libltcsmpte from the source code.

Version 0.4.4							  Fri Apr 27 2012						     SMPTEFrame(3)
All times are GMT -4. The time now is 11:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy