How to eliminate OR clause when joining tables? Post: 302962344

10 More Discussions You Might Find Interesting

1. 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:...

2. UNIX for Dummies Questions & Answers

if clause

hi, pls could you help me with one program in KSH ( i have sunOS). I need to create an If clause, that prints an error message and filenames, when in a directory are found some files of null size (find . -type f -size 0 ). thanks

3. Shell Programming and Scripting

Dynamic SQL for where clause

Hi, I have an app which user can query the database based on 4 criteria, that is Field1, Field2, Field3 and Field4 Mya I know how to write a dynamic SQL where I can choose to retrieve data based on their selected value. eg. where Field1=AAA eg. where Field1=AAA and Field2=BBB eg....

4. Shell Programming and Scripting

multiple conditions in 'if clause'

Hi, When i use the below code snippet in my shell script OFC_10.sh: if then echo "Success" exit 2 elif then echo "Failure" exit 6 I get the error message: ./OFC_10.sh: line 41: ' ./OFC_10.sh: line 45: ' Line 41 is the line where If loop starts and line 45 is...

5. Shell Programming and Scripting

How to eliminate ^L

Hi, I am trying to create a text file from data retrieved from a query.The data retrieved is having this character '^L' at regular intervals of the data. How can i eliminate this, Please find below the sample data. I tried sed -e "s/\^L//g" to convert it, but with no luck ^LCODE*SERIAL...

6. Shell Programming and Scripting

Use a shell variable in where clause

Hi all, I want to use a variable inside my sql query and below is my script: #!/bin/ksh export b="abcd" a=`sqlplus -s abc/def@ghi <<++ set heading off; set feedback off; select xxx from mytable where clmn_nm='$b'; exit; ++` echo $a But the output i get is below: $>...

7. Shell Programming and Scripting

If clause in perl

HI friends , I am very new to perl .please dont mind if i ask silly questions. I seee below code in one sript if ( exists $ENV{FMTWRP_TMP_DIR} and $ENV{FMTWRP_TMP_DIR} ) { $tdir = $ENV{FMTWRP_TMP_DIR}; } whats does this mean . I am very confused about the if clauses in...

8. Shell Programming and Scripting

../ in perl and if clause

Hi can anyone please explain what the below code does? i mean $fide_stopfile = ? when $FIDE_SCR = '/fs/dir1/dir2/common/scr' and also little confused with if clause too. what it check? $fide_stopfile = "$ENV{FIDE_SCR}/../tmp/STOP"; if ( -e $fide_stopfile > 0 ) { ...

9. Shell Programming and Scripting

How to search for a directory with if clause?

Hello All, I want to do a conditional search for a directory, i.e pathname=/abc/def foldername=xyz if ( $pathname/$foldername/aaa ) then .................. fi Here i am searching for aaa directory inside the path and if it exist then it should go inside the loop. Can...

10. Shell Programming and Scripting

If clause query

Hi, i need to add a condition in my IF clause where i need to check if the file exists in a folder and return true out of it. but in my directory i have multiple files with same name but datestamp append on it for e.g. export f1 = filename export f2=filename1 if ] then echo "No...

LEARN ABOUT CENTOS

font::ttf::kern

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)