Hi, I have a shell script which analyses the log folder for a specific string and throws me the output. I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help?
The output which I get
The output format which I want in a excel is
I want this output as columns in excel
Last edited by Scrutinizer; 09-15-2019 at 03:41 PM..
Hi All,
I have seen many examples of spooling query output in csv file.
But I want to spool the query results in proper excel file.
Can you guys help me on this? (4 Replies)
Hi
I want to export DOS output of find command in Excel.
However I want information to be in different column and not in same.
I am using this command
set /p String_to_search='Enter String to search !'
set /p File_to_search='Enter File to search !'
findstr /N "%String_to_search%"... (0 Replies)
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
A) Write a script, which will take input from a file and convert the number from Centigrade to Fahrenheit... (5 Replies)
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Hi guys - I have a file and output like this below:
File: myfile.dat
File has content like this: ABCD, 34, 456, 2324
I would like excel to have this:
Name (ABCD) Quantity (34), Type (456), Status (2324)
(Name, Quantity, Type and Status are columns)
I would like to export... (4 Replies)
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)
Hi, I have a shell script which analyses the log folder for a specific string and throws me the output. I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help?
The output which I get
Server1 : count... (14 Replies)
Hi, All:
I have one for ... loop code to generate a list of rename statement. However, echo the loop output on screen is OK. But store the echo output into a file is not working. So come here to seek help. My basic code is:
! /bin/ksh
echo > DAS_VetFed.txt
dir=/mydirectory
cd $dir
files=`ls... (6 Replies)
Discussion started by: duke0001
6 Replies
LEARN ABOUT OPENSOLARIS
time
time(1T) Tcl Built-In Commands time(1T)__________________________________________________________________________________________________________________________________________________NAME
time - Time the execution of a script
SYNOPSIS
time script ?count?
_________________________________________________________________DESCRIPTION
This command will call the Tcl interpreter count times to evaluate script (or once if count isn't specified). It will then return a string
of the form
503 microseconds per iteration
which indicates the average amount of time required per iteration, in microseconds. Time is measured in elapsed time, not CPU time.
EXAMPLE
Estimate how long it takes for a simple Tcl for loop to count to a thousand:
time {
for {set i 0} {$i<1000} {incr i} {
# empty body
}
}
SEE ALSO clock(1T)KEYWORDS
script, time
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+-----------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+-----------------+
|Availability | SUNWTcl |
+--------------------+-----------------+
|Interface Stability | Uncommitted |
+--------------------+-----------------+
NOTES
Source for Tcl is available on http://opensolaris.org.
Tcltime(1T)