Sponsored Content
Top Forums Shell Programming and Scripting Print a key with its all values using awk/others Post 302408083 by Scrutinizer on Sunday 28th of March 2010 02:58:39 AM
Old 03-28-2010
awk:
Code:
awk '{ if (NR==1)
         for (i=1;i<=NF;i++) L[i]=$i
       else {
         v=1
         delete O
         for (i=2;i<=NF;i++) {
           if (!O[$i]) 
             O[$i]=v++
           print $1"\t"L[i]"\t"$i"\t"O[$i]
         }
       }
     }' infile

output:
Code:
I_1     a1      a/a     1
I_1     a2      a/a     1
I_1     a3      a/b     2
I_1     a6      a/b     2
I_1     a8      a/a     1
I_1     a9      b/b     3
I_2     a1      b/b     1
I_2     a2      b/b     1
I_2     a3      b/b     1
I_2     a6      b/b     1
I_2     a8      b/c     2
I_2     a9      b/d     3
I_3     a1      c/c     1
I_3     a2      c/c     1
I_3     a3      c/d     2
I_3     a6      c/e     3
I_3     a8      c/e     3
I_3     a9      c/e     3


Last edited by Scrutinizer; 03-28-2010 at 04:06 AM.. Reason: Corrected occurrence
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pick values from column based on key values by usin AWK

Dear Guyz:) I have 2 different input files like this. I would like to pick the values or letters from the inputfile2 based on inputfile1 keys (A,F,N,X,Z). I have done similar task by using awk but in that case the inputfiles are similar like in inputfile2 (all keys in 1st column and values in... (16 Replies)
Discussion started by: repinementer
16 Replies

2. UNIX for Advanced & Expert Users

Awk to print values of second file

Hello, I have a data file with 300,000 records in it, and another file which contains only the line numbers of roughly 13,000 records in the data file which have data integrity issues. I'm trying to find a way to print the original data by line number identified in the second file. How can I do... (2 Replies)
Discussion started by: peteroc
2 Replies

3. Shell Programming and Scripting

Extract key words and print their values

Input file (HTTP request log file): GET... (2 Replies)
Discussion started by: buptwy
2 Replies

4. Shell Programming and Scripting

match two key columns in two files and print output (awk)

I have two files... file1 and file2. Where columns 1 and 2 of file1 match columns 1 and 2 of file2 I want to create a new file that is all file1 + columns 3 and 4 of file2 :b: Many thanks if you know how to do this.... :b: file1 31-101 106 0 92 31-101 106 29 ... (2 Replies)
Discussion started by: pelhabuan
2 Replies

5. Shell Programming and Scripting

How to print in awk matching $1 values ,to $1,$4 example given.?

Hi Experts, I am trying to get the output from a matching pattern but unable to construct the awk command: file : aa bb cc 11 dd aa cc 33 cc 22 45 68 aa 33 44 44 dd aa cc 37 aa 33 44 67 I want the output to be : ( if $1 match to "aa" start of the line,then print $4 of that line, and... (3 Replies)
Discussion started by: rveri
3 Replies

6. Shell Programming and Scripting

awk print odd values

value=$(some command) for all in `echo $value` do awk checks each value (all) to see if it is a odd number. if so, prints the value done sounds easy enough but i've been unable to find anything on google. (2 Replies)
Discussion started by: SkySmart
2 Replies

7. Shell Programming and Scripting

awk - Print whole string ending with a Tab if key matched

Hi , I am looking to print the whole string from file2.txt but it is only printing 77 but not the whole matched string from File2.txt Any help is appreciated. Thanks, Script awk ' BEGIN { OFS="\t" out = "a.txt"} NR==FNR && NF {a=$0; next} function print_65_11() { if... (11 Replies)
Discussion started by: High-T
11 Replies

8. UNIX for Dummies Questions & Answers

awk - Print lines if only matching key is found

I am looking to move matching lines (01 - 07) from File1 and 77 tab the matching string from File2, to File3.txt. I am almost done but - Currently, script is not printing lines to File3.txt in order. Thanks a lot. Any help is appreciated. Script I am using: awk 'FNR == NR && ! /^]*$/ {... (9 Replies)
Discussion started by: High-T
9 Replies

9. Shell Programming and Scripting

Fetch the values based on a Key using awk from single file

Hi, Please help to fetch the values for a key from below data format in linux. Sample Input Data Format 11055005|PurchaseCondition|GiftQuantity|1 11055005|PurchaseCondition|MinimumPurchase|400 11055005|GiftCatalogEntryIdentifier|Id|207328014 11429510|PurchaseCondition|GiftQuantity|1... (2 Replies)
Discussion started by: mohanalakshmi
2 Replies

10. Shell Programming and Scripting

Print values within groups of lines with awk

Hello to all, I'm trying to print the value corresponding to the words A, B, C, D, E. These words could appear sometimes and sometimes not inside each group of lines. Each group of lines begins with "ZYX". My issue with current code is that should print values for 3 groups and only is... (6 Replies)
Discussion started by: Ophiuchus
6 Replies
IMAGEANTIALIAS(3)							 1							 IMAGEANTIALIAS(3)

imageantialias - Should antialias functions be used or not

SYNOPSIS
bool imageantialias (resource $image, bool $enabled) DESCRIPTION
Activate the fast drawing antialiased methods for lines and wired polygons. It does not support alpha components. It works using a direct blend operation. It works only with truecolor images. Thickness and styled are not supported. Using antialiased primitives with transparent background color can end with some unexpected results. The blend method uses the background color as any other colors. The lack of alpha component support does not allow an alpha based antialiasing method. PARAMETERS
o $ image -An image resource, returned by one of the image creation functions, such as imagecreatetruecolor(3). o $enabled - Whether to enable antialiasing or not. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 A comparison of two lines, one with anti-aliasing switched on <?php // Setup an anti-aliased image and a normal image $aa = imagecreatetruecolor(400, 100); $normal = imagecreatetruecolor(200, 100); // Switch antialiasing on for one image imageantialias($aa, true); // Allocate colors $red = imagecolorallocate($normal, 255, 0, 0); $red_aa = imagecolorallocate($aa, 255, 0, 0); // Draw two lines, one with AA enabled imageline($normal, 0, 0, 200, 100, $red); imageline($aa, 0, 0, 200, 100, $red_aa); // Merge the two images side by side for output (AA: left, Normal: Right) imagecopymerge($aa, $normal, 200, 0, 0, 0, 200, 100, 100); // Output image header('Content-type: image/png'); imagepng($aa); imagedestroy($aa); imagedestroy($normal); ?> The above example will output something similar to:[NOT DISPLAYABLE MEDIA]Output of example : A comparison of two lines, one with anti-aliasing switched on NOTES
SEE ALSO
imagecreatetruecolor(3). PHP Documentation Group IMAGEANTIALIAS(3)
All times are GMT -4. The time now is 12:11 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy