Sponsored Content
Top Forums Shell Programming and Scripting awk Help: Filter Multiple Entry & print in one line. Post 302763251 by Yoda on Tuesday 29th of January 2013 07:11:33 PM
Old 01-29-2013
Inserted newline at end:
Code:
awk ' NR==1 {           # If first record
   p=$1;                # Set p = field 1
   printf "%s ",$0;     # printf entire record in same line
   next;
} p==$1 {               # if p == field 1
   printf "%s ",$2;     # printf only field 2 in same line
} p!=$1 {               # if p != field 1
   printf "\n%s ",$0;   # printf entire record in newline
   p=$1;                # Set p = field 1
   next;
} END {
   printf "\n";
}' filename

This User Gave Thanks to Yoda For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

filter out a sequence from multiple lines line

Hi, I have an unwanted string at random lines of my verilog (*.v) file. (* abccddee *) input A; (* xyz *) input B; (* 1234 *) output C; I want a clean file like this: input A; input B; output C; the unwanted string begins with "(*" and ends with "*)" at multiple lines. Any help... (2 Replies)
Discussion started by: return_user
2 Replies

2. Shell Programming and Scripting

awk: Multiple search patterns & print in an one liner

I would like to print result of multiple search pattern invoked from an one liner. The code looks like this but won't work gawk -F '{{if ($0 ~ /pattern1/) pat1=$1 && if ($0 ~ /pattern2/) pat2=$2} ; print pat1, pat2}' Can anybody help getting the right code? (10 Replies)
Discussion started by: sdf
10 Replies

3. Shell Programming and Scripting

AWK filter from file and print

Dear all, I am using awk to filter some data like this:- awk 'NR==FNR{a;next}($1 in a)' FS=":" filter.dat data.dat >! out.dat where the filter and input data look like this:- filter.dat... n_o00j_1900_40_007195350_0:n_o00j_1940_40_007308526... (3 Replies)
Discussion started by: atb299
3 Replies

4. Linux

awk filter & Auto gen Mail

hi experts 2012-01-30 10:30:01:812 "y" "NA" "30/01/2012 10:30:01:154 AM" 2012-01-30 10:33:46:342 "y" "NA" "30/01/2012 10:33:45:752 AM" 2012-01-30 10:41:11:148 "n" "200" "30/01/2012 10:41:10:558 AM" 2012-01-30 10:44:48:049 "y" "NA" ... (7 Replies)
Discussion started by: nith_anandan
7 Replies

5. Shell Programming and Scripting

select entry from consecutive line awk

Hi folks, I have a file with four columns that looks like the following (tab separated) 1 1 1 a 2 2 2 b 3 3 3 c 4 4 4 d I would like to create a file with always 4 columns but where the third entry corresponds to the thirst entry of the next line and so on, to get the following 1 1 2 a... (4 Replies)
Discussion started by: klebsiella
4 Replies

6. Shell Programming and Scripting

(awk?) print multiple lines on one line

I have a log file something like ------- report 1 ------- date 27/01/13 time 08:00 records 1234 ------- report 2------- date 27/01/13 time 08:00 records 1239 ... I'd like output to show as report 1,date 27/01/13,time 08:00,records 1234 report 2,date 27/01/13,time... (6 Replies)
Discussion started by: gefa
6 Replies

7. Shell Programming and Scripting

awk : Filter a set of data to parse header line and last field of multiple same match.

Hi Experts, I have a data with multiple entry , I want to filter PKG= & the last column "00060110" or "00088150" in the output file: ############################################################################################### PKG= P8SDB :: VGS = vgP8SOra vgP8SDB1 vgP8S001... (5 Replies)
Discussion started by: rveri
5 Replies

8. Shell Programming and Scripting

awk to filter multiple lines

Hi. I need to filter lines based upon matches in multiple tab-separated columns. For all matching occurrences in column 1, check the corresponding column 4. IF all column 4 entries are identical, discard all lines. If even one entry in column 4 is different, then keep all lines. How can I... (5 Replies)
Discussion started by: owwow14
5 Replies

9. UNIX for Dummies Questions & Answers

How to create a print filter that print text & image?

Currently, I have a print filter that takes a text file, that convert it into PCL which then gets to a HP printer. This works. Now I need to embedded a image file within the text file. I'm able to convert the image file into PCL and I can cat both files together to into a single document... (1 Reply)
Discussion started by: chedlee88-1
1 Replies

10. Shell Programming and Scripting

How to replace multiple "&nbsp;" entry with in <td> tag into single entry using sed?

I have the input file like this. Input file: 12.txt 1) There are one or more than one <tr> tags in same line. 2) Some tr tags may have one <td> or more tna one <td> tags within it. 3) Few <td> tags having "<td> &nbsp; </td>". Few having more than one "&nbsp;" entry in it. <tr> some td... (4 Replies)
Discussion started by: thomasraj87
4 Replies
CUBRID_FIELD_SEEK(3)							 1						      CUBRID_FIELD_SEEK(3)

cubrid_field_seek - Move the result set cursor to the specified field offset

SYNOPSIS
bool cubrid_field_seek (resource $result, [int $field_offset]) DESCRIPTION
This function moves the result set cursor to the specified field offset. This offset is used by cubrid_fetch_field(3) if it doesn't include a field offset. It returns TRUE on success or FALSE on failure. PARAMETERS
o $result -$result comes from a call to cubrid_execute(3) o $field_offset - The numerical field offset. The $field_offset starts at 0. If $field_offset does not exist, an error of level E_WARNING is also issued. RETURN VALUES
TRUE on success. FALSE on failure. EXAMPLES
Example #1 cubrid_field_seek(3) example <?php $conn = cubrid_connect("localhost", 33000, "demodb"); $req = cubrid_execute($conn, "SELECT event_code,athlete_code,nation_code,game_date FROM game WHERE host_year=1988 and event_code=20001;"); var_dump(cubrid_fetch_row($req)); cubrid_field_seek($req, 1); $field = cubrid_fetch_field($req); printf(" --- Field Properties --- "); printf("%-30s %s ", "name:", $field->name); printf("%-30s %s ", "table:", $field->table); printf("%-30s "%s" ", "default value:", $field->def); printf("%-30s %d ", "max length:", $field->max_length); printf("%-30s %d ", "not null:", $field->not_null); printf("%-30s %d ", "unique key:", $field->unique_key); printf("%-30s %d ", "multiple key:", $field->multiple_key); printf("%-30s %d ", "numeric:", $field->numeric); printf("%-30s %s ", "type:", $field->type); cubrid_close_request($req); cubrid_disconnect($conn); ?> The above example will output: array(4) { [0]=> string(5) "20001" [1]=> string(5) "16132" [2]=> string(3) "KOR" [3]=> string(9) "1988-09-30" } --- Field Properties --- name: athlete_code table: game default value: "" max length: 0 not null: 1 unique key: 1 multiple key: 0 numeric: 1 type: integer PHP Documentation Group CUBRID_FIELD_SEEK(3)
All times are GMT -4. The time now is 08:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy