Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

output spacing and formatting

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers output spacing and formatting
# 8  
Old 10-02-2012
As I pointed out before, for awk, col 5 IS "Mir" and "RW" and "(M)" respectivly. Looks like your program just skips that column instead of ouputting FS""FS, which then would be identifyable by awk.
Do you have a chance to influence the input file? Pls. post the output of your first command USING CODE TAGS!
# 9  
Old 10-02-2012
sorry.. here is the source where i am filtering.

Code:
        ----------------------------------------------------------------------------------
                                                      Sym  Device                     Cap
        LdevName              PdevName                Dev  Config        Att. Sts     (MB)
        ----------------------------------------------------------------------------------
        D-data1               N/A                     2DB3 RAID-5             RW     60338
        D-data2               N/A                     2DB4 RAID-5             RW     60338
        D-data3               N/A                     2DB5 RAID-5             RW     60338
        D-data4               N/A                     2DB6 RAID-5             RW     60338
        D-data5               N/A                     02ED RAID-5             RW     60338
        D-data6               N/A                     0E86 RAID-5             RW     60338
        D-index1              N/A                     2DB7 RAID-5             RW     60338
        D-index2              N/A                     2DB8 RAID-5             RW     60338
        D-index3              N/A                     0E87 RAID-5             RW     60338
        D-undo                N/A                     2DB9 RAID-5             RW     60338
        D-arch                N/A                     2DBB RAID-5             RW     60338
        D-redoa               N/A                     2127 2-Way Mir          RW     10260
        D-redob               N/A                     2128 2-Way Mir          RW     10260
        D-db                  N/A                     10AE RAID-5             RW     17428
        D-data7               N/A                     03C1 RAID-5        (M)  RW    120675
        D-index4              N/A                     34BD RAID-5             RW     60338

and my current output:

Code:
NAME           DEV id    Size    Meta
D-data1        2DB3     60338      RW
D-data2        2DB4     60338      RW
D-data3        2DB5     60338      RW
D-data4        2DB6     60338      RW
D-data5        02ED     60338      RW
D-data6        0E86     60338      RW
D-index1       2DB7     60338      RW
D-index2       2DB8     60338      RW
D-index3       0E87     60338      RW
D-undo         2DB9     60338      RW
D-arch         2DBB     60338      RW
D-redoa        2127     10260     Mir
D-redob        2128     10260     Mir
D-db           10AE     17428      RW
D-data7        03C1     120675    (M)
D-index4       34BD     60338      RW

as you can see in the Meta column instead of the (M) only there is RW and Mir in there.
# 10  
Old 10-02-2012
So the input seems to be arranged by padding spaces in between the fields. How come the "RW" is so misaligned in several places? Pls. eliminate the headings, reduce the no. of lines to very few and post the output of od -tx1 infile.
# 11  
Old 10-02-2012
here is the code again, seems it doesnt see the NULL values in the Att column. the last column of my desired output should either be (M) or a space.

Code:
symdg show $INS-${SNAP} | egrep "D-" | awk 'BEGIN {print "NAME           DEV id    Size    Meta"}{printf "%-14s %-8s %-8s %4s\n",$1,$3,$NF,$5}'

# 12  
Old 10-02-2012
That code is needless; pls show the output of symdg show $INS-${SNAP} | od -tx1

We can cheat and supply an empty $5 field:
Code:
sed -r 's/(^.{73}) {3}/\1---/;s/(^.{64}) /\1-/' file|
awk 'BEGIN {print "NAME         DEV id Size    Meta"}{printf "%12s %5s %7s %3s\n",$1,$3,$NF,$5}'

giving
Code:
     D-data1  2DB3   60338 ---
     D-data2  2DB4   60338 ---
     D-data3  2DB5   60338 ---
     D-data4  2DB6   60338 ---
     D-data5  02ED   60338 ---
     D-data6  0E86   60338 ---
    D-index1  2DB7   60338 ---
    D-index2  2DB8   60338 ---
    D-index3  0E87   60338 ---
      D-undo  2DB9   60338 ---
      D-arch  2DBB   60338 ---
     D-redoa  2127   10260 ---
     D-redob  2128   10260 ---
        D-db  10AE   17428 ---
     D-data7  03C1  120675 (M)
    D-index4  34BD   60338 ---

This User Gave Thanks to RudiC For This Post:
prodigy06
# 13  
Old 10-04-2012
Thanks a lot Rudic, im good now
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

Formatting output

I have the output like below: DEV#: 9 DEVICE NAME: hdisk9 TYPE: 1750500 ALGORITHM: Load Balance SERIAL: 68173531021 ========================================================================== Path# Adapter/Path Name State Mode Select Errors 0 ... (4 Replies)
Discussion started by: Daniel Gate
4 Replies

3. Shell Programming and Scripting

Preserving file format and spacing in output file

Hi I have a file with the following structure "VATTENFALL GLOBAL" "Vattenfall Tray" "BARCLAYS BANK LONDON" "Capula" "P1 AGEAS GLOBAL COMPANY" "AAC - Optiver" The requirement is like this 1) Take 2 input... (16 Replies)
Discussion started by: sudeep.id
16 Replies

4. Shell Programming and Scripting

Output formatting .

below is a CPU utilization Log for ABC server. However for every 15 minutes it generates 3 CPU values(with interval of 2 sec). Host CPU CPUtotal CPU% time ABC 101.1 2 50.55 14 : 15 ABC 100.5 2 50.25 14 : 15 ABC 100.2 2 50.1 14 : 15 ABC 100.9 2 50.45 14 : 30 ABC 100.5 2 50.25 14 : 30 ABC... (5 Replies)
Discussion started by: pinga123
5 Replies

5. 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

6. Shell Programming and Scripting

Output formatting

I have input file in this way 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 ... (8 Replies)
Discussion started by: vakharia Mahesh
8 Replies

7. Shell Programming and Scripting

Formatting my output

Dear All, I am new to unix scripting. I need your help to format my output on screen. echo " --------------------------------------------" echo " | My Output |" echo " --------------------------------------------" echo " | A: $A... (5 Replies)
Discussion started by: rahiljavaid
5 Replies

8. 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

9. 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

10. 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
Login or Register to Ask a Question