Putting values into order in a field using awk Post: 302720717

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK - printing certain fields when field order changes in data file

I'm hoping someone can help me on this. I have a data file that greatly simplified might look like this: sec;src;dst;proto 421;10.10.10.1;10.10.10.2;tcp 426;10.10.10.3;10.10.10.4;udp 442;10.10.10.5;10.10.10.6;tcp sec;src;fac;dst;proto 521;10.10.10.1;ab;10.10.10.2;tcp...

2. UNIX for Dummies Questions & Answers

Awk search for max and min field values

hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value. BEGIN {FS=","; max=0} NF == 7 {if (max < $6) max = $6;} END { print man, min} where $6 is the column of a field separated by a comma

3. Shell Programming and Scripting

counting lines containing two column field values with awk

Hello everybody, I'm trying to count the number of consecutive lines in a text file which have two distinctive column field values. These lines may appear in several line blocks within the file, but I only want a single block to be counted. This was my first approach to tackle the problem (I'm...

4. Shell Programming and Scripting

AWK: combining consecutive values in a field

Hi, Here is my sample input X 2 AAA Y 3 BBB Y 2 CCC Z 4 DDD In field 1, if the value of one line is same as that of next line, I want to concatenate the corresponding value of the second line in the third field with the value of the third field of first line. And I dont need the third...

5. Shell Programming and Scripting

SED/AWK to edit/add field values in a record

Hi Experts, I am new to shell scripting. Need some help in doing one task given by the customer. The sample record in a file is as follows: 3538,,,,,,ID,ID1,,,,,,,,,,, It needs to be the following: 3538,,353800,353800,,,ID,ID1,,,,,COLX,,,,,COLY, And i want to modify this record in...

6. Shell Programming and Scripting

awk help - matching a field with certail values

Hello there, I have a file with few fields separated by ":". I wrote a below awk to manipulate this file: awk 'BEGIN { FS=OFS=":" }\ NR != 1 && $2 !~ /^98/ && $8 !~ /^6/{print $0}' $in_file > $out_file What I wanted was that if $8 field contains any of the values - 6100, 6110, 6200 -...

7. UNIX for Dummies Questions & Answers

Values with common field in same line with awk

Hi all ! I almost did it but got a small problem. input: cars red cars blue cars green truck black Wanted: cars red-blue-green truck black Attempt: gawk 'BEGIN{FS="\t"}{a = a (a?"-":"")$2; $2=a; print $1 FS $2}' input But I also got the intermediate records...

8. UNIX for Dummies Questions & Answers

Generating all possible combinations of values in field 1 (awk)

Input: A|1 B|2 C|3 D|4 Output: A+B|3 A+C|4 A+D|5 B+C|5 B+D|6 C+D|7 A+B+C|6 A+B+D|7 A+C+D|8 B+C+D|9 A+B+C+D|10 I only managed to get the output for pairs of $1 values (i.e. combination of length 2):

9. Shell Programming and Scripting

Insert field values in a record using awk command

Hi Friends, Below is my input file with "|" (pipe) as filed delimiter: My Input File: HDR|F1|F2||||F6|F7 I want to inser values in the record for field 4 and field 5. Expected output HDR|F1|F2||F4|F5|F6|F7 I am able to append the string to the end of the record, but not in between the...

10. UNIX for Beginners Questions & Answers

awk GSUB read field values from multiple text files

My program run without error. The problem I am having. The program isn't outputting field values with the column headers to file.txt. Each of the column headers in file.txt has no data. MEMSIZE SECOND SASFoundation Filename The output results in file.txt should show: ...

LEARN ABOUT PHP

cubrid_column_types

CUBRID_COLUMN_TYPES(3)							 1						    CUBRID_COLUMN_TYPES(3)

cubrid_column_types - Get column types in result

SYNOPSIS

       array cubrid_column_types (resource  $req_identifier)

DESCRIPTION

	The cubrid_column_types(3) function gets column types of query results by using $req_identifier.

PARAMETERS

	      o $req_identifier
		-Request identifier.

RETURN VALUES

	Array of string values containing the column names, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_column_types(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb", "dba");
	      $result = cubrid_execute($conn, "SELECT * FROM game WHERE host_year=2004 AND nation_code='AUS' AND medal='G'");

	      $column_names = cubrid_column_names($result);
	      $column_types = cubrid_column_types($result);

	      printf("%-30s %-30s %-15s
", "Column Names", "Column Types", "Column Maxlen");
	      for($i = 0, $size = count($column_names); $i < $size; $i++) {
		  $column_len = cubrid_field_len($result, $i);
		  printf("%-30s %-30s %-15s
", $column_names[$i], $column_types[$i], $column_len);
	      }

	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      Column Names		     Column Types		    Column Maxlen
	      host_year 		     integer			    11
	      event_code		     integer			    11
	      athlete_code		     integer			    11
	      stadium_code		     integer			    11
	      nation_code		     char			    3
	      medal			     char			    1
	      game_date 		     date			    10

SEE ALSO

       cubrid_column_names(3), cubrid_prepare(3), cubrid_execute(3).

PHP Documentation Group 												    CUBRID_COLUMN_TYPES(3)