Format output from command from variables


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Format output from command from variables
# 1  
Old 04-05-2012
Question Format output from command from variables

Hi , I have below command to that outputs from variables..
command:
Code:
 echo $INSTANCE $DATAB  $status $TSLastBackup| awk '{printf("%-8s %-8s \t \n",$1,$2,$3,$4)}'  | tee $LOGF

the ouput is now:
Code:
INSTANCE     DATABSE    BACKUP_STATUS    BACKUPTIMESTAMP
-------      --------   --------         --------

ab2f001           ABC        F      20120403200014
ab2t003           DBDCDD          F      20120403200241
ab2t005           ADFDFDFF         F      20120403200341
ab2t006            DFDF           F      20120403200921
ab2t009          DF           Y      20120404200013
ab2t009          DFDF            Y      20120404200049
ab2t016            DFDF          Y      20120404200118
ab2t017      DFDFFD      Y      20120404200204
ab2t099     DFDF         F       20120329200013

I want the ouput looks like below :

all the columns should align to the same lenght

Code:
A B C D
X Y X D
M N OP

the Y/F column format should align in a same straight colmns.

any awk or sed command for this


Moderator's Comments:
Mod Comment Welcome to the UNIX and Linux Forums. Please use code tags. Video tutorial on how to use them

Last edited by Scrutinizer; 04-05-2012 at 03:05 PM..
# 2  
Old 04-05-2012
If your shell supports printf, use that instead of echo for formatted output:
Code:
$ cat x.dat
ab2f001           ABC        F      20120403200014
ab2t003           DBDCDD          F      20120403200241
ab2t005           ADFDFDFF         F      20120403200341
ab2t006            DFDF           F      20120403200921
ab2t009          DF           Y      20120404200013
ab2t009          DFDF            Y      20120404200049
ab2t016            DFDF          Y      20120404200118
ab2t017      DFDFFD      Y      20120404200204
ab2t099     DFDF         F       20120329200013
$ cat x
#!/bin/ksh

while read a b c d
do
  printf "%7s  %-8s  %1s  %s\n" $a $b $c $d
done < x.dat
$ ./x
ab2f001  ABC       F  20120403200014
ab2t003  DBDCDD    F  20120403200241
ab2t005  ADFDFDFF  F  20120403200341
ab2t006  DFDF      F  20120403200921
ab2t009  DF        Y  20120404200013
ab2t009  DFDF      Y  20120404200049
ab2t016  DFDF      Y  20120404200118
ab2t017  DFDFFD    Y  20120404200204
ab2t099  DFDF      F  20120329200013
$

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read several variables from command output via SSH

Hi Folks, I'm currently trying to read several values into different variables. Actually, what I'm doing works, but I get an error message. My attempts are: read strCPROC strIPROC strAPROC <<<$(ssh -n -T hscroot@$HMC "lshwres -r proc -m $strIDENT --level sys -F \"configurable_sys_proc_units... (11 Replies)
Discussion started by: NKaede
11 Replies

2. Shell Programming and Scripting

Get the output of w command in pipe delimited format

Since output of w command have variable number of columns I want to get the output in pipe delimited format. I tried export OFS="|"; w but that does not work. Any ideas? (4 Replies)
Discussion started by: Soham
4 Replies

3. Shell Programming and Scripting

How to format output of command?

Hi how do you change the format of the output of ls -lt -c -R $HOME | sed /^total/d From: /home/pikamon/Desktop: -rwxr-xr-x 1 pikamon pikamon 35 Sep 18 14:25 fileModified.sh -rwxr-xr-x 1 pikamon pikamon 87 Sep 18 14:25 fileModified.sh~ /home/darksky21/Downloads: -rwxrw-rw- 1 pikamon... (5 Replies)
Discussion started by: pikamon
5 Replies

4. Shell Programming and Scripting

Grep command output in tabular format

I have a grep command script which works fine and give the correct results but i wanted the output to be displayed in tabular format ? Is it possible to display the output in tabular format and as well direct them to some file. main script : #!/usr/bin/bash Start_Time=`date '+%m%d%y... (1 Reply)
Discussion started by: Optimus81
1 Replies

5. Shell Programming and Scripting

UNIX command output in csv format

I'm just wondering is there any way to capture the output of a unix command in a csv format. df -h gives the result of filesystem,free space,Used space, use %,mounted on. Is there a way to capture the command output and format it as comma sparated or fixed length file. (3 Replies)
Discussion started by: anita81
3 Replies

6. UNIX for Dummies Questions & Answers

UNIX command output format

how can I get the df -h command output into excel format or csv file. df -k | tr -s " " | sed 's/ /, /g' | sed '1 s/, / /g' | column -t df -h | column -t I have tried as above but the format is not right. I'm not able to load the format into a excel or a table. ... (2 Replies)
Discussion started by: anita81
2 Replies

7. Shell Programming and Scripting

Format output into columns, variables with multiple entries

Hello all, I've got a script that collects data on file systems and prints out specific data about each. I've formatted headers w/ printf like so. printf "\033 and I had the content of the varibles printed out beneath those columns like so: printf... (5 Replies)
Discussion started by: awreneau
5 Replies

8. Shell Programming and Scripting

Format output in AWK command

hi Friends , I have a file as below s.txt 1~2~~4 2~6~~7 3~8~~9 t.txt 1~2~~4 2~5~8~7 3~8~~7 header for both files is common (2 Replies)
Discussion started by: i150371485
2 Replies

9. Shell Programming and Scripting

Help me to command to output file format.

Dear Master. Help me to command to out put. Ex log. "<?xml version=""1.0"" encoding=""UTF-10"" ?><anova-test-bom> <txid>17251032659</txid> <authentication> <user>admin</user> <password>Amrduoi</password> </authentication> <destination> <msisdn>1111111</msisdn> ... (2 Replies)
Discussion started by: ooilinlove
2 Replies

10. Shell Programming and Scripting

Format Output with AWK command

Hi - I have a file with contents as below. 12.1 a.txt 12.1 b.txt 12.1 c.txt 13.2 a.txt 13.2 d.txt 14.3 f.txt 15.4 a.txt 15.4 b.txt 15.4 z.txt I need to print the contents like this. 12.1 a.txt <&nbsp><&nbsp><&nbsp>b.txt <&nbsp><&nbsp><&nbsp>c.txt (7 Replies)
Discussion started by: guruparan18
7 Replies
Login or Register to Ask a Question