Sponsored Content
Full Discussion: Matching tables
Top Forums UNIX for Beginners Questions & Answers Matching tables Post 303042438 by nezabudka on Tuesday 24th of December 2019 02:48:56 PM
Old 12-24-2019
maybe this is very redundant for such task,
but maybe this will anticipate possible problems with more complex input
This instance with integrated version control Smilie requires gnu awk
Code:
awk '
NR == FNR       { T[$2] = $1 (T[$2]?FS T[$2]:""); next }
                { lin = 0; for (i=1; i<=NF; i++)
                        if ($i in T) lin++ 
                }
lin == NF       { for (i=1; i<=NF; i++) {
                        if (T[$i]) print $i FS gensub(/^.*\s/, "", 1, T[$i])
                        sub(/\s?[^ ]+$/, "", T[$i])
                        }
                }
' Table2 Table1


Last edited by nezabudka; 12-24-2019 at 04:13 PM..
These 2 Users Gave Thanks to nezabudka For This Post:
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Routing tables

Hey guys, I needed to add a route to my routing table and I got it to work but on reboot it gets removed. Anyone know what file I can add this route to so it stays on the machine after a reboot? (9 Replies)
Discussion started by: kingdbag
9 Replies

2. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies

3. Shell Programming and Scripting

tables in scripts

Hi , I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1, t3= t1 - t2 t3= t1 - t2 I am new to scripts, any help please? thanks (7 Replies)
Discussion started by: Celine19
7 Replies

4. Shell Programming and Scripting

comparing two tables

I am comparing two table structure in different databases,Put into 2 txt files , when comparing if column sequnce and data type is not matching ,it has to display that info else Table structure is ok. wrote shell script ,its not working .I am getting "Table structure is not ok" even if both... (1 Reply)
Discussion started by: akil
1 Replies

5. UNIX for Dummies Questions & Answers

VI editor and tables

I have a host table that looks similar like this: # IP Name Comment 10.10.10.1 Lab1-1 # Static for Lab1 subnet 10.10.10.2 Lab1-2 # Static for Lab1 subnet 10.10.10.3 Lab1-3 ... (2 Replies)
Discussion started by: mjl927
2 Replies

6. Shell Programming and Scripting

Insert lines above matching line with content from matching

Hi, I have text file: Name: xyz Gender: M Address: "120_B_C; ksilskdj; lsudlfw" Zip: 20392 Name: KLM Gender: F Address: "65_D_F; wnmlsi;lsuod;,...." Zip:90233I want to insert 2 new lines before the 'Address: ' line deriving value from this Address line value The Address value in quotes... (1 Reply)
Discussion started by: ysrini
1 Replies

7. Shell Programming and Scripting

Selecting tables

Hi, Can anyone help me that, How to see the table fields in Oracle database through shell script(ksh). I have tried with the following: sqlplus -s $user/$passwd@$sid << SQL >> session.log select * from Testtab.sql I'm not able to see anything.. Thanks (4 Replies)
Discussion started by: zxcjggu708
4 Replies

8. Shell Programming and Scripting

Compare file1 for matching line in file2 and print the difference in matching lines

Hello, I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Discussion started by: RasB15
2 Replies

9. Shell Programming and Scripting

awk to combine all matching dates and remove non-matching

Using the awk below I am able to combine all the matching dates in $1, but I can not seem to remove the non-matching from the file. Thank you :). file 20161109104500.0+0000,x,5631 20161109104500.0+0000,y,2 20161109104500.0+0000,z,2 20161109104500.0+0000,a,4117... (3 Replies)
Discussion started by: cmccabe
3 Replies
Font::TTF::Kern(3)					User Contributed Perl Documentation					Font::TTF::Kern(3)

NAME
Font::TTF::Kern - Kerning tables DESCRIPTION
Kerning tables are held as an ordered collection of subtables each giving incremental information regarding the kerning of various pairs of glyphs. The basic structure of the kerning data structure is: $kern = $f->{'kern'}{'tables'}[$tnum]{'kerns'}{$leftnum}{$rightnum}; Due to the possible complexity of some kerning tables the above information is insufficient. Reference also needs to be made to the type of the table and the coverage field. INSTANCE VARIABLES
The instance variables for a kerning table are relatively straightforward. Version Version number of the kerning table Num Number of subtables in the kerning table tables Array of subtables in the kerning table Each subtable has a number of instance variables. kern A two level hash array containing kerning values. The indexing is left value and then right value. In the case of type 2 tables, the indexing is via left class and right class. It may seem using hashes is strange, but most tables are not type 2 and this method saves empty array values. type Stores the table type. Only type 0 and type 2 tables are specified for TrueType so far. coverage A bit field of coverage information regarding the kerning value. See the TrueType specification for details. Version Contains the version number of the table. Num Number of kerning pairs in this type 0 table. left An array indexed by glyph - left_first which returns a class number for the glyph in type 2 tables. right An array indexed by glyph - right_first which returns a class number for the glyph in type 2 tables. left_first the glyph number of the first element in the left array for type 2 tables. right_first the glyph number of the first element in the right array for type 2 tables. num_left Number of left classes num_right Number of right classes METHODS
$t->read Reads the whole kerning table into structures $t->out($fh) Outputs the kerning tables to the given file $t->XML_element($context, $depth, $key, $value) Handles outputting the kern hash into XML a little more tidily BUGS
o Only supports kerning table types 0 & 2. o No real support functions to do anything with the kerning tables yet. AUTHOR
Martin Hosken Martin_Hosken@sil.org. See Font::TTF::Font for copyright and licensing. POD ERRORS
Hey! The above document had some coding errors, which are explained below: Around line 38: You can't have =items (as at line 42) unless the first thing after the =over is an =item perl v5.16.3 2012-02-23 Font::TTF::Kern(3)
All times are GMT -4. The time now is 10:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy