04-04-2011
Hi All... thanks for all your amazing replies
@kato - ur code is working absolutely fine
@sk1418 - i liked ur code for the output format... but when i tried to use it in my script it is giving error for "column -s" command
error diaplayed is :
./log_test4.ksh[23]: column: not found
i also tried to man column but it seems it is not supported here
pht025a2:/home/oper/pk264w/log_script> man column
No manual entry for column.
This is what i used...
awk '{print "|"$4"#|"$7"#|"$9"# |"}' mail_log_status.log | column -s"#" -t | awk 'BEGIN{line=""}{l=length($0);if(length(line)
==0)for(i=1;i<l;i++)line=line"-";print line;print $0}END{print line}'
Can You please halp me again
Thanks in Advance
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
ALL,
My shell script takes a employee file as input.
I have to identify the list of employees not in the input file and update their status in the database.
Approach I followed:
by traversing through the input file add all the emplid's to a variable.
update the status of employees not in... (2 Replies)
Discussion started by: sailussr
2 Replies
2. Shell Programming and Scripting
Hi,
I have data in my text file something like this.
adams
robert
ahmed
gibbs
I want to use this data line by line as input to an sql query which i run by connecting to an oracle database from shell.
If you have code for similar scenario , please ehlp.
I want the output of the sql query... (7 Replies)
Discussion started by: rdhanek
7 Replies
3. Shell Programming and Scripting
Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies
4. Shell Programming and Scripting
All,
problem Description: For example: I have two shell scripts(executables). let name it as script1 and script2.I'm trying to execute script1 from script2. while executing script2, script1 is asking for manual input(input from keyboard).
Now i need to know how I can skip this user input... (3 Replies)
Discussion started by: techie99
3 Replies
5. Shell Programming and Scripting
hi,
i have a text file that looks like this!
i want to generate an excel sheet out of it, removing all the junk data except the addresses
that look like
. Arrow Electrical Services
Rotating Machinery, Electrical Contracting & Mining Specialists
Onsite maintenance, breakdown... (8 Replies)
Discussion started by: vemkiran
8 Replies
6. Shell Programming and Scripting
Hi,
I have a data file with :
01/28/2012,1,1,98995
01/28/2012,1,2,7195
01/29/2012,1,1,98995
01/29/2012,1,2,7195
01/30/2012,1,1,98896
01/30/2012,1,2,7083
01/31/2012,1,1,98896
01/31/2012,1,2,7083
02/01/2012,1,1,98896
02/01/2012,1,2,7083
02/02/2012,1,1,98899
02/02/2012,1,2,7083
I... (1 Reply)
Discussion started by: himanish
1 Replies
7. 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
8. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
9. Shell Programming and Scripting
I have input data looks like this which is a part of a csv file
7,1265,76548,"0102:04"
8,1266,76545,"0112:04"
I need to make the output data should look like this and the output data will be part of text file:
7|1265000 |7654899 |A|
8|12660000 |76545999 |B|
The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies
10. UNIX for Beginners Questions & Answers
//file begin =====
//some code
task abcd_;
input x;
input y,z; //some comment
output w; //some comment
reg p;
integer q;
begin
//some code
end
endtask : abcd_
//some code
//file end =====
expected output from above... (1 Reply)
Discussion started by: rishifrnds
1 Replies
PR(1) General Commands Manual PR(1)
NAME
pr - print file
SYNOPSIS
pr [ option ... ] [ file ... ]
DESCRIPTION
Pr produces a printed listing of one or more files on its standard output. The output is separated into pages headed by a date, the name
of the file or a specified header, and the page number. With no file arguments, pr prints its standard input.
Options apply to all following files but may be reset between files:
-n Produce n-column output.
+n Begin printing with page n.
-b Balance columns on last page, in case of multi-column output.
-d Double space.
-en Set the tab stops for input text every n spaces.
-h Take the next argument as a page header (file by default).
-in Replace sequences of blanks in the output by tabs, using tab stops set every n spaces.
-f Use formfeeds to separate pages.
-ln Take the length of the page to be n lines instead of the default 66.
-m Print all files simultaneously, each in one column.
-n Number the lines of each file.
-on Offset the left margin n character positions.
-sc Separate columns by the single character c instead of aligning them with white space. A missing c is taken to be a tab.
-t Do not print the 5-line header or the 5-line trailer normally supplied for each page.
-wn For multi-column output, take the width of the page to be n characters instead of the default 72.
SOURCE
/sys/src/cmd/pr.c
SEE ALSO
cat(1), lp(1)
PR(1)