Sponsored Content
Top Forums Shell Programming and Scripting Major Awk problems (Searching, If statements, transposing etc.) Post 70847 by Blivo on Wednesday 4th of May 2005 03:40:24 PM
Old 05-04-2005
Major Awk problems (Searching, If statements, transposing etc.)

Please bare with me as task is very detailed and I'm extremely new to Awk/sed. Keep in mind I'm running windows so I'm using a dos prompt

The attachment is a server report that I'm trying to manipulate with little success. For each server, I need to take the most recent information about them and then have them put into a file. After I have the most recent information, I have to transpose my rows into columns so instead of:

System Availability 100.00%
Total Uptime 551d 8h 12m 23s
Total Downtime 0d 0h 24m 51s
Total Reboots 11
Mean Time Between Reboots 50.12 days
Total Bluescreens 0

I would get:
System Availability Total Uptime Total Downtime
100.00% 551d 8h 12m 23 s 0d 0h 24m 51s

the rest of the rows would be included also.

However, some of the servers have two different sets of information and I need the most recent. Also, some of the servers do not display all of the information so I need still need those rows to be aligned in the proper columns.

I've been working on this for awhile so any help will be greatly appreciate.

Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

having problems with IF statements

below is a sample of the shell script im trying to get working. if the script is run with no data it should display the usage. if data1 is given it should grep with todays date and if data1 and a date are giving it should grep using the date given. please let me know what im doing wrong ive tried... (5 Replies)
Discussion started by: jrelax
5 Replies

2. Shell Programming and Scripting

Transposing columns with awk

I want a sweet simple time efficient awk script in online which gets output 001_r 0.0265185 0.0437049 0.0240642 0.0310264 0.0200482 0.0146746 0.0351344 0.0347856 0.036119 1.49 firstcoloumnvalue allvaluesof 'c' in one row 001_r : 002_r c: 0.0265185 N: 548 001_r : 007_r c:... (5 Replies)
Discussion started by: phoenix_nebula
5 Replies

3. Shell Programming and Scripting

awk, string as record separator, transposing rows into columns

I'm working on a different stage of a project that someone helped me address elsewhere in these threads. The .docs I'm cycling through look roughly like this: 1 of 26 DOCUMENTS Copyright 2010 The Age Company Limited All Rights Reserved The Age (Melbourne, Australia) November 27, 2010... (9 Replies)
Discussion started by: spindoctor
9 Replies

4. Shell Programming and Scripting

Transposing text using AWK

Well I thought that this would be a fairly straight forward operation but perhaps I'm complicating it more in my mind. I have a simple data.txt file containing candidate information in the following format: "ANTONIA ROJAS SALES" "Feminino" "13/06/1954" "Casado(a)" "Brasileira... (6 Replies)
Discussion started by: daveyabe
6 Replies

5. Shell Programming and Scripting

Execution Problems with if statements

Hi all, I habe a file called test.log, which contain following data : 0.0 0.1 0.1 0.1 0.1 0.2 0.3 0.3 0.4 0.4 0.6 8.7 8.8 17.2 I want to show the data which gater than 9.0 But my script not working. (4 Replies)
Discussion started by: mnmonu
4 Replies

6. Shell Programming and Scripting

awk problem - combining awk statements

i have a datafile that has several lines that look like this: 2,dataflow,Sun Mar 17 16:50:01 2013,1363539001,2990,excelsheet,660,mortar,660,4 using the following command: awk -F, '{$3=strftime("%a %b %d %T %Y,%s",$3)}1' OFS=, $DATAFILE | egrep -v "\-OLDISSUES," | ${AWK} "/${MONTH} ${DAY}... (7 Replies)
Discussion started by: SkySmart
7 Replies

7. Shell Programming and Scripting

Awk/sed script for transposing any number of rows with header row

Greetings! I have been trying to find out a way to take a CSV file with a large number of rows, and a very large number of columns (in the thousands) and convert the rows to a single column of data, where the first row is a header representing the attribute name and the subsequent series of... (3 Replies)
Discussion started by: tntelle
3 Replies

8. Shell Programming and Scripting

Nested awk Statements

Hello again everyone, yes, I'm back again for more help! So I'm attempting to read two separate files and generate some XML code from that. My current code is: BEGIN { print "<?xml version=\"1.0\" encoding=\"utf-8\">" print "<Export>" } { x=1; print "<section name=\"Query" NR "\">"... (5 Replies)
Discussion started by: Parrakarry
5 Replies

9. Shell Programming and Scripting

awk with many if statements

Hi What is the right structure to use awk with multiple If statements The following code doesn't work # awk ' { A = $1 } END { for ( i = 1; i <= c; i++ ) { if ( A == 236 && A ==199... (7 Replies)
Discussion started by: khaled79
7 Replies

10. Shell Programming and Scripting

Searching for pattern in variable using case statements

i would like to search a variable for a pattern, without having make any calls to external tools. i have a code like this: COUNTPRO2="gine is very bad vine is pretty good" case "${COUNTPRO2}" in *vine*) factor=${COUNTPRO2} echo $factor ;; esac If the variable contains... (7 Replies)
Discussion started by: SkySmart
7 Replies
CURL_GETINFO(3) 							 1							   CURL_GETINFO(3)

curl_getinfo - Get information regarding a specific transfer

SYNOPSIS
mixed curl_getinfo (resource $ch, [int $opt]) DESCRIPTION
Gets information about the last transfer. PARAMETERS
o $ch -A cURL handle returned by curl_init(3). o $opt - This may be one of the following constants: o CURLINFO_EFFECTIVE_URL - Last effective URL o CURLINFO_HTTP_CODE - Last received HTTP code o CURLINFO_FILETIME - Remote time of the retrieved document, if -1 is returned the time of the document is unknown o CURLINFO_TOTAL_TIME - Total transaction time in seconds for last transfer o CURLINFO_NAMELOOKUP_TIME - Time in seconds until name resolving was complete o CURLINFO_CONNECT_TIME - Time in seconds it took to establish the connection o CURLINFO_PRETRANSFER_TIME - Time in seconds from start until just before file transfer begins o CURLINFO_STARTTRANSFER_TIME - Time in seconds until the first byte is about to be transferred o CURLINFO_REDIRECT_COUNT - Number of redirects, with the CURLOPT_FOLLOWLOCATION option enabled o CURLINFO_REDIRECT_TIME - Time in seconds of all redirection steps before final transaction was started, with the CUR- LOPT_FOLLOWLOCATION option enabled o CURLINFO_REDIRECT_URL - With the CURLOPT_FOLLOWLOCATION option disabled: redirect URL found in the last transaction, that should be requested manually next. With the CURLOPT_FOLLOWLOCATION option enabled: this is empty. The redirect URL in this case is available in CURLINFO_EFFECTIVE_URL o CURLINFO_PRIMARY_IP - IP address of the most recent connection o CURLINFO_PRIMARY_PORT - Destination port of the most recent connection o CURLINFO_LOCAL_IP - Local (source) IP address of the most recent connection o CURLINFO_LOCAL_PORT - Local (source) port of the most recent connection o CURLINFO_SIZE_UPLOAD - Total number of bytes uploaded o CURLINFO_SIZE_DOWNLOAD - Total number of bytes downloaded o CURLINFO_SPEED_DOWNLOAD - Average download speed o CURLINFO_SPEED_UPLOAD - Average upload speed o CURLINFO_HEADER_SIZE - Total size of all headers received o CURLINFO_HEADER_OUT - The request string sent. For this to work, add the CURLINFO_HEADER_OUT option to the handle by call- ing curl_setopt(3) o CURLINFO_REQUEST_SIZE - Total size of issued requests, currently only for HTTP requests o CURLINFO_SSL_VERIFYRESULT - Result of SSL certification verification requested by setting CURLOPT_SSL_VERIFYPEER o CURLINFO_CONTENT_LENGTH_DOWNLOAD - content-length of download, read from Content-Length: field o CURLINFO_CONTENT_LENGTH_UPLOAD - Specified size of upload o CURLINFO_CONTENT_TYPE - Content-Type: of the requested document, NULL indicates server did not send valid Content-Type: header o CURLINFO_PRIVATE - Private data associated with this cURL handle, previously set with the CURLOPT_PRIVATE option of curl_setopt(3) RETURN VALUES
If $opt is given, returns its value. Otherwise, returns an associative array with the following elements (which correspond to $opt), or FALSE on failure: o "url" o "content_type" o "http_code" o "header_size" o "request_size" o "filetime" o "ssl_verify_result" o "redirect_count" o "total_time" o "namelookup_time" o "connect_time" o "pretransfer_time" o "size_upload" o "size_download" o "speed_download" o "speed_upload" o "download_content_length" o "upload_content_length" o "starttransfer_time" o "redirect_time" o "certinfo" o "primary_ip" o "primary_port" o "local_ip" o "local_port" o "redirect_url" o "request_header" (This is only set if the CURLINFO_HEADER_OUT is set by a previous call to curl_setopt(3)) Note that private data is not included in the associative array and must be retrieved individually with the CURLINFO_PRIVATE option. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.4.7 | | | | | | | Introduced CURLINFO_PRIMARY_IP, CURLINFO_PRI- | | | MARY_PORT, CURLINFO_LOCAL_IP and | | | CURLINFO_LOCAL_PORT. | | | | | 5.3.7 | | | | | | | Introduced CURLINFO_REDIRECT_URL. | | | | | 5.2.4 | | | | | | | Introduced CURLINFO_PRIVATE. | | | | | 5.1.3 | | | | | | | Introduced CURLINFO_HEADER_OUT. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 curl_getinfo(3) example <?php // Create a curl handle $ch = curl_init('http://www.yahoo.com/'); // Execute curl_exec($ch); // Check if any error occurred if(!curl_errno($ch)) { $info = curl_getinfo($ch); echo 'Took ' . $info['total_time'] . ' seconds to send a request to ' . $info['url']; } // Close handle curl_close($ch); ?> NOTES
Note Information gathered by this function is kept if the handle is re-used. This means that unless a statistic is overridden internally by this function, the previous info is returned. PHP Documentation Group CURL_GETINFO(3)
All times are GMT -4. The time now is 03:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy