Sponsored Content
Full Discussion: Long to wide format
Top Forums Shell Programming and Scripting Long to wide format Post 302875725 by Subbeh on Wednesday 20th of November 2013 08:08:21 AM
Old 11-20-2013
Try this:
Code:
awk '{
  a[$2,$1]=a[$1,$2]=$3
  l[$1];l[$2]
 }
 END {
  for (i in l) {
   printf "%10s", i
  }
  printf "\n"
  for (i in l) {
   printf "%-10s", i
   for (j in l) {
    printf "%-10s", a[i,j]?a[i,j]:0
   }
   printf "\n"
  }
 }' file

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ls -l output with long iso format

Hello everbody, I've a list of logfiles (transfer1.log, transfer2.log, ... transfer168.log.) Each of these was created at the end of the actual month and I've to write a script to calculate the utilisation ratio of the actual month of the system. I don't want to scan every logfile, so I've to... (1 Reply)
Discussion started by: rofflox
1 Replies

2. Shell Programming and Scripting

Help with find command and list in a long format each found file

The purpose of those comands are to find the newest file in a directory acvrdind to system date, and it has to be recursively found in each directory. The problem is that i want to list in a long format every found file, but the commands i use produce unexpected results ,so the output lists in a... (5 Replies)
Discussion started by: alexcol
5 Replies

3. UNIX for Dummies Questions & Answers

Terminal too wide

Hi Experts, It may be a trivial thing, but I am stuck. Whenver I try to open a file using vi I get error Terminal Too wide. I am using putty to connect to a Sun OS. Please advice. bash-2.05$ vi all_subs_ded_20080203.txt Terminal too wide :q 1 more file to edit:q (3 Replies)
Discussion started by: RishiPahuja
3 Replies

4. UNIX for Dummies Questions & Answers

city wide connection

what would be the best way to phyisically connect a series of computerised bus stops to a central computer in a city-wide network?? (3 Replies)
Discussion started by: spitfireuk1
3 Replies

5. Shell Programming and Scripting

Validate long date format in If statement

Hi, I want to validate if the given input is a valid month (written in long month format) Jan / Feb / Mar / Apr / May / Jun etc etc This is what I've got with || (or statements): #!/usr/bin/ksh INPUT_DATE=$1 FORMATTED_DATE=`date | cut -f2 -d' '` #If there's no input use the... (1 Reply)
Discussion started by: Batsies
1 Replies

6. Shell Programming and Scripting

modify ls -l (long listing format output) strictly using SED only straightforward goalhard 4 me doh

Below is a sample out of ls -l which I would like to rearrange or modify by field numbers for example I successfully managed to disect using simple paragraph however for ls -l I can't divide the rows or fields by field number. Successful modification by fields using SED sample: $ sed -e... (1 Reply)
Discussion started by: wolf@=NK
1 Replies

7. Shell Programming and Scripting

Long list file display different time format.

Hi Gurus, I have some weird issue. when using ls -l the result shows different time format: -rw-r--r-- 1 abc gourp1 3032605576 Jun 14 2013 abc -rw-rw-r-- 1 abc gourp1 1689948832 Aug 10 06:22 abc one display 2013 which is year; another one displays 06:22 which is time. ... (4 Replies)
Discussion started by: ken6503
4 Replies

8. AIX

World Wide Name (FLEX)

Does anyone know how to find the Worl Wide Name (WWN) on a IBM flex system ? (4 Replies)
Discussion started by: Tharsan
4 Replies

9. Shell Programming and Scripting

System-wide search

When looking for wherever a program or a filename appears in the system, a short scrip is "findinner" which another script calls with a long parameter list consisting of path names ending with ".sh" or ".menu". "findinner" looks like this: # If not .savenn file, show name and result of grep. #... (4 Replies)
Discussion started by: wbport
4 Replies
CUBRID_GET_SERVER_INFO(3)						 1						 CUBRID_GET_SERVER_INFO(3)

cubrid_get_server_info - Return the CUBRID server version

SYNOPSIS
string cubrid_get_server_info (resource $conn_identifier) DESCRIPTION
This function returns a string that represents the CUBRID server version. PARAMETERS
o $conn_identifier -The CUBRID connection. RETURN VALUES
A string that represents the CUBRID server version; on success. FALSE on failure. EXAMPLES
Example #1 cubrid_get_server_info(3) example <?php printf("%-30s %s ", "CUBRID PHP Version:", cubrid_version()); printf(" "); $conn = cubrid_connect("localhost", 33088, "demodb"); if (!$conn) { die('Connect Error ('. cubrid_error_code() .')' . cubrid_error_msg()); } $db_params = cubrid_get_db_parameter($conn); while (list($param_name, $param_value) = each($db_params)) { printf("%-30s %s ", $param_name, $param_value); } printf(" "); $server_info = cubrid_get_server_info($conn); $client_info = cubrid_get_client_info(); printf("%-30s %s ", "Server Info:", $server_info); printf("%-30s %s ", "Client Info:", $client_info); printf(" "); $charset = cubrid_get_charset($conn); printf("%-30s %s ", "CUBRID Charset:", $charset); cubrid_disconnect($conn); ?> The above example will output: CUBRID PHP Version: 9.1.0.0001 PARAM_ISOLATION_LEVEL 3 LOCK_TIMEOUT -1 MAX_STRING_LENGTH 1073741823 PARAM_AUTO_COMMIT 1 Server Info: 9.1.0.0212 Client Info: 9.1.0 CUBRID Charset: iso8859-1 PHP Documentation Group CUBRID_GET_SERVER_INFO(3)
All times are GMT -4. The time now is 07:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy