06-05-2012
Quote:
Originally Posted by
superHonda123
The formatting is a little bit out of alignment when it's sent out via email.
Also, for column: "#AB" and "#CD", sometimes there is a value, sometimes it's just empty so need to take this into consideration for output alignment.
How to make it in a better format with proper alignment?
It would have helped to post the script. Changing scripts we don't know is a bit hard to do and my crystal ball which reveals any secret to me is in repair at the moment. Therefore just some general directions instead of concrete help:
Have a look at the "printf()" function. It works the same as system call (in C/C++), as ksh-builtin or as awk-builtin. You provide a format string and a list of variables to fill the spots. In the format strings you can define the output width you want to use and if you want it left- or right-aligned. By using proper values you get tabular column-output automatically.
I hope this helps.
bakunin
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am trying to check if if column 5 is greater than 90. If greater it will print the term in column 6, else if all are within limit, then it will output "Size is within limit". I can't seem to do that with the below code. The output should only be 1 statement of "Size is within the... (4 Replies)
Discussion started by: Raynon
4 Replies
2. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
3. Shell Programming and Scripting
Hi Experts,
I am adding a column of numbers with awk , however not getting correct output:
# awk '{sum+=$1} END {print sum}' datafile
2.15291e+06
How can I getthe output like : 2152910
Thank you..
# awk '{sum+=$1} END {print sum}' datafile
2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies
4. Shell Programming and Scripting
Input File:
1234567890123456789012345678901234
----------------------------------
11111 XXX xxxxx 6666666666
22222 YYY 2222222222
33333 AAA TTT xxxxx 9999999999
44444
55555 RRR UUU 5555555555
66666 TTT nnnnn 2222222222
77777 XXX ... (4 Replies)
Discussion started by: lordsmiter
4 Replies
5. Shell Programming and Scripting
INPUT FILE:
9780743565219 "GODS OF NEWPORT" "JAKES, JOHN" 2006
OUTPUT FILE I NEED to CREATE FROM INPUT FILE:
cd /data/audiobooks/9780743565219
~/Desktop/mp3-to-m4b 9780743565219-GODS OF NEWPORT "GODS OF NEWPORT" "JAKES, JOHN" 2006 n ---------- Post updated at 04:19 PM ----------... (6 Replies)
Discussion started by: glev2005
6 Replies
6. Shell Programming and Scripting
Am new to AWk, Can anyone help me to get excepected output from given input please.
input file
student: name
details of them = details_needed
class: 5th_needed
adress: address_needed
Expected output:
details of them = 5th_needed = address_needed
---------- Post updated at... (5 Replies)
Discussion started by: Elavarasan
5 Replies
7. Shell Programming and Scripting
Need some help .. in formating some input
INPUT FILE
IMAGE ap00m43 0 0 8 ap00m43_1318914034 UNIX_STANDARD_ADC_2 0 *NULL* root Daily 1 0 1318914034 408 1319518834 0
HISTO -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
FRAG 1 1 0 0 2 20 6 G11890 ts00p71 65536
FRAG 1 2 13440 0 2 20 7 G11890 ts00p71... (2 Replies)
Discussion started by: greycells
2 Replies
8. Shell Programming and Scripting
Hello
Here is an easy one
Data file
12345 (tab) Some text (tab) 53.432
23456 (tab) Some longer text (tab) 933.422
34567 (tab) Some different text (tab) 29.309
I need to awk these three tab-delimited columns so that the first two are unchanged (unformatted) and the third shows two decimal... (1 Reply)
Discussion started by: palex
1 Replies
9. Shell Programming and Scripting
Hello,
I shall like using the function awk to modify the contents of the following file:
/tmp/conf-1 -sec=sys,rw=lpar1:lpar2:lpar3,access=lpar1:lpar2:lpar3
/tmp/conf-2 -vers=4,sec=sys,rw=lpar4:lpar5:lpar6,access=lpar4:lpar5:lpar6
I need to have the result below towards another file
... (5 Replies)
Discussion started by: khalidou13
5 Replies
10. Shell Programming and Scripting
Guys ,, pls .. need help with this ...
File 1
0A6C Not Visible ???:? NA:NA TDEV N/Grp'd NR 5121
0A6D Not Visible ***:* NA:NA TDEV N/Grp'd RW 33784
0A6E Not Visible ***:* NA:NA TDEV N/Grp'd RW 33784... (4 Replies)
Discussion started by: greycells
4 Replies
LEARN ABOUT XFREE86
neaten
NEATEN(1) General Commands Manual NEATEN(1)
NAME
neaten - neaten up output columns
SYNOPSIS
neaten [ format ]
DESCRIPTION
Neaten reads from its standard input and neatens up columns separated by white space using the specified format. The format is a string
consisting of a positive integer followed by an alignment character and another integer. The alignment character is usually a decimal
point ('.'), but it can be any non-digit.
The alignment character is used as the central point of each column. The total column field width will be the number to the left of the
alignment character plus one for the alignment character itself plus the number to the right of the alignment character.
If a field does not contain the alignment character, it will be printed to the left of where the alignment character would have appeared.
If a field is too long to print within the specified format, the entire field will be printed and that row will not be aligned with the
rest.
The default format is "8.8".
EXAMPLE
To examine a file with columns of numbers:
neaten 10.8 < input | more
BUGS
Columns wider than the total width of the format specification will be printed without any separating white space.
The program does not do anything special with tabs on the input.
AUTHOR
Greg Ward
SEE ALSO
cnt(1), rcalc(1), rlam(1), total(1)
RADIANCE
11/15/93 NEATEN(1)