01-18-2008
help on formatting output (Table Form)
Data in File
ABC
EFGHI:123
ABCZYE
EFI:123
ABCFGD
EF:123
ABCEERRRRR
EFGHI:123
Expected Format
1 ABC DEFGHIFE 123
2 ABCZYE DEFI 123
3 ABCFGD DEF 123
4 ABCEERRRRR DEFGHI 123
However when i enter the following command:
awk 'BEGIN {FS=":"}{printf("%u %s\t%s\t%s\n", NR, $1, $2, $3)} END {print "End List"}' data.txt
Actual Output
1 ABC DEFGHIFE 123
2 ABCZYE DEFI 123
3 ABCFGD DEF 123
4 ABCEERRRRR DEFGHI 123
how can i set the width of each column?
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi frnds,
i have a file:
where 1st field is:
eventType,eventTime,loggingTime, probableCause,lsname,slCode
and is 2nd field hav its values and everytime its starting with communicationsAlarm
on the behalf of communicationsAlarm
eventType communicationsAlarm, ... (3 Replies)
Discussion started by: dodasajan
3 Replies
2. Shell Programming and Scripting
May data
Name = Andi
Address = none
Phone = 82728
Name = Peter
Address = none
Phone = 98799
The expected output
Name,Address,Phone
Andi,none,82728
Peter,none,98799
what i have done (6 Replies)
Discussion started by: before4
6 Replies
3. Shell Programming and Scripting
Hi All,
I have result log file which looks like this (below): from the content need to consolidate the result and put it in tabular form
1). Intercomponents Checking
Passed: All Server are passed.
======================================================================
2). OS version Checking... (9 Replies)
Discussion started by: Optimus81
9 Replies
4. Shell Programming and Scripting
hi,
I have a script which is dispaying the output as below:
Column 3:value1
Column 4:value 4
column 8:value 8
column 9:value 9
column 13:value 13
Column 3:value10
Column 4:value 40
column 8:value 80
column 9:value 90
column 13:value 103
However,I need the output in tabular... (5 Replies)
Discussion started by: Vivekit82
5 Replies
5. Shell Programming and Scripting
Hi,
I have a csv file from which i am fetching few columns as below:
IFILE=/home/home1/Report1.csv
OFILE=/home/home1/`date +"%m%d%y%H%M%S"`.dat
if #Checks if file exists and readable
then
awk -F "," '(NR>4) {print $1,$6,$2,$3,$4,$5,$6}' ${IFILE} >> ${OFILE}
fi
cat $OFILE | mail... (7 Replies)
Discussion started by: Vivekit82
7 Replies
6. Shell Programming and Scripting
#! /bin/ksh
#] && . ./.profile 2>/dev/null
if test -f '.profile'; then . ./.profile; fi;
#. .profile
LOG_DIR=/app/rpx/jobs/scripts/just/logs
sendEmail()
{
pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7"
(
... (21 Replies)
Discussion started by: ankit.mca.aaidu
21 Replies
7. Shell Programming and Scripting
Hi
I have the below output:
736f14c4-eda2-4531-9d40-9de4d6d1fb0f
An account already exists for this email address. Please enter a different email address.
c3716baf-9bf8-42da-8a44-a13fff68d20f
An account already exists for this email address. Please enter a different email address.
Is... (4 Replies)
Discussion started by: ankur328
4 Replies
8. Shell Programming and Scripting
Dear experts,
I need bit help in formatting ..
I have csv file file , i will read that file by passing one column value as input parameter and display header row and corresponding row for that parameter.
I have shell script like this:
#!/bin/bash
#key_word_I_am_looking_for=$1
#awk... (16 Replies)
Discussion started by: onenessboy
16 Replies
9. Shell Programming and Scripting
Hello guys,
I want to parse a JSON file in order to get the data in a table form.
My JSON file is like this:
{
"document":{
"page":
},
{
"column":
}
]
},
{
... (6 Replies)
Discussion started by: Gescad
6 Replies
LEARN ABOUT DEBIAN
perl::critic::policy::controlstructures::prohibitunreachablecode
Perl::Critic::Policy::ControlStructures::ProhibitUnreachUserCContributed PerlPerl::Critic::Policy::ControlStructures::ProhibitUnreachableCode(3pm)
NAME
Perl::Critic::Policy::ControlStructures::ProhibitUnreachableCode - Don't write code after an unconditional "die, exit, or next".
AFFILIATION
This Policy is part of the core Perl::Critic distribution.
DESCRIPTION
This policy prohibits code following a statement which unconditionally alters the program flow. This includes calls to "exit", "die",
"return", "next", "last" and "goto". Due to common usage, "croak" and "confess" from Carp are also included.
Code is reachable if any of the following conditions are true:
o Flow-altering statement has a conditional attached to it
o Statement is on the right side of an operator "&&", "||", "//", "and", "or", or "err".
o Code is prefixed with a label (can potentially be reached via "goto")
o Code is a subroutine
EXAMPLES
# not ok
exit;
print "123
";
# ok
exit if !$xyz;
print "123
";
# not ok
for ( 1 .. 10 ) {
next;
print 1;
}
# ok
for ( 1 .. 10 ) {
next if $_ == 5;
print 1;
}
# not ok
sub foo {
my $bar = shift;
return;
print 1;
}
# ok
sub foo {
my $bar = shift;
return if $bar->baz();
print 1;
}
# not ok
die;
print "123
";
# ok
die;
LABEL: print "123
";
# not ok
croak;
do_something();
# ok
croak;
sub do_something {}
CONFIGURATION
This Policy is not configurable except for the standard options.
SEE ALSO
Perl::Critic::Policy::ControlStructures::ProhibitPostfixControls
AUTHOR
Peter Guzis <pguzis@cpan.org>
COPYRIGHT
Copyright (c) 2006-2011 Peter Guzis. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of this license
can be found in the LICENSE file included with this module.
perl v5.14.2 2012-06-0Perl::Critic::Policy::ControlStructures::ProhibitUnreachableCode(3pm)