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 PHP
msgfmt_parse_message
MSGFMT_PARSE_MESSAGE(3) 1 MSGFMT_PARSE_MESSAGE(3)
MessageFormatter::parseMessage - Quick parse input string
Object oriented style
SYNOPSIS
publicstatic array MessageFormatter::parseMessage (string $locale, string $pattern, string $source)
DESCRIPTION
Procedural style
array msgfmt_parse_message (string $locale, string $pattern, string $value)
Parses input string without explicitly creating the formatter object. Use this function when the format operation is done only once and
does not need and parameters or state to be kept.
PARAMETERS
o $locale
- The locale to use for parsing locale-dependent parts
o $pattern
- The pattern with which to parse the $value.
o $source
- The string to parse, conforming to the $pattern.
RETURN VALUES
An array containing items extracted, or FALSE on error
EXAMPLES
Example #1
msgfmt_parse_message(3) example
<?php
$fmt = msgfmt_parse_message('en_US', "{0,number,integer} monkeys on {1,number,integer} trees make {2,number} monkeys per tree",
"4,560 monkeys on 123 trees make 37.073 monkeys per tree");
var_export($fmt);
$fmt = msgfmt_parse_message('de', "{0,number,integer} Affen auf {1,number,integer} Baumen sind {2,number} Affen pro Baum",
"4.560 Affen auf 123 Baumen sind 37,073 Affen pro Baum");
var_export($fmt);
?>
Example #2
OO example
<?php
$fmt = MessageFormatter::parseMessage('en_US', "{0,number,integer} monkeys on {1,number,integer} trees make {2,number} monkeys per tree",
"4,560 monkeys on 123 trees make 37.073 monkeys per tree");
var_export($fmt);
$fmt = MessageFormatter::parseMessage('de', "{0,number,integer} Affen auf {1,number,integer} Baumen sind {2,number} Affen pro Baum",
"4.560 Affen auf 123 Baumen sind 37,073 Affen pro Baum");
var_export($fmt);
?>
The above example will output:
array (
0 => 4560,
1 => 123,
2 => 37.073,
)
array (
0 => 4560,
1 => 123,
2 => 37.073,
)
SEE ALSO
msgfmt_create(3), msgfmt_format_message(3), msgfmt_parse(3).
PHP Documentation Group MSGFMT_PARSE_MESSAGE(3)