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
Server1 server2 server3 ...... server7
Count count count ...... count
I want this output as columns in excel
Last edited by RavinderSingh13; 09-15-2019 at 12:59 PM..
I have a forloop which checks a log for a set of 6 static IP addresses and each IP found is logged to a file which is then mailed to me.
After the forloop I always have a text file that may contain up to 6 IP addresses or may contain 0.
What I want to do is substitute the IP addresses (if any)... (2 Replies)
Hi all
I run my program prog.c in the following way :
$ ./prog 1 > output.txt where 1 is a user defined initial value used by the program.
But now I want to run it for many a thousand initial values, 1-1000, and store all the outputs in different files.
Like
$ ./prog 1... (1 Reply)
I'd like to parse TOP output file containing data like the below, and then be able to import the parsed file in to Excel where I can easily generate graphs. Ideally, the output would have a single column for each value in the output.
Any thoughts on how to get started with this, or a better... (3 Replies)
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
I am facing a problem formatting the output of my shell script in excel.
We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation).
Also, leading zeroes(if any) in the output are getting... (4 Replies)
Hello,
I have a single text file with three columns like:
2 1 10
3 6 11
4 4 12
5 5 13
6 8 14
I was wondering how I can run a shell script to (do loop) to read the first point in the first column , compare it with all the points in the second column and if they are the same,... (12 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 All,
I have below perl script which writes xml from .xls file.
Now i want to add below two conditions in this script :
1. to check if the the input .xls file has ony two columns , if more tahn two columns then script should pop up an error.
2. If there are two columns , then first column... (4 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... (1 Reply)
Discussion started by: srilaxman
1 Replies
LEARN ABOUT PHP
count
COUNT(3) 1 COUNT(3)count - Count all elements in an array, or something in an objectSYNOPSIS
int count (mixed $array_or_countable, [int $mode = COUNT_NORMAL])
DESCRIPTION
Counts all elements in an array, or something in an object.
For objects, if you have SPL installed, you can hook into count(3) by implementing interface Countable. The interface has exactly one
method, Countable::count, which returns the return value for the count(3) function.
Please see the Array section of the manual for a detailed explanation of how arrays are implemented and used in PHP.
PARAMETERS
o $array_or_countable
- An array or Countable object.
o $mode
- If the optional $mode parameter is set to COUNT_RECURSIVE (or 1), count(3) will recursively count the array. This is particu-
larly useful for counting all the elements of a multidimensional array.
Caution
count(3) can detect recursion to avoid an infinite loop, but will emit an E_WARNING every time it does (in case the array
contains itself more than once) and return a count higher than may be expected.
RETURN VALUES
Returns the number of elements in $array_or_countable. If the parameter is not an array or not an object with implemented Countable inter-
face, 1 will be returned. There is one exception, if $array_or_countable is NULL, 0 will be returned.
Caution
count(3) may return 0 for a variable that isn't set, but it may also return 0 for a variable that has been initialized with an empty
array. Use isset(3) to test if a variable is set.
EXAMPLES
Example #1
count(3) example
<?php
$a[0] = 1;
$a[1] = 3;
$a[2] = 5;
$result = count($a);
// $result == 3
$b[0] = 7;
$b[5] = 9;
$b[10] = 11;
$result = count($b);
// $result == 3
$result = count(null);
// $result == 0
$result = count(false);
// $result == 1
?>
Example #2
Recursive count(3) example
<?php
$food = array('fruits' => array('orange', 'banana', 'apple'),
'veggie' => array('carrot', 'collard', 'pea'));
// recursive count
echo count($food, COUNT_RECURSIVE); // output 8
// normal count
echo count($food); // output 2
?>
SEE ALSO is_array(3), isset(3), strlen(3).
PHP Documentation Group COUNT(3)