example sql:
select a.a1,b.b1,c.c1,d.d1,e.e1
from a
left outer join b on a.x=b.x
left outer join c on b.y=c.y
left outer join d on d.z=a.z
inner join a.t=e.t
I know how single outer or inner join works in sql.
But I don't really understand when there are multiple of them.
can... (0 Replies)
Hello,
My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns:
File A: (tab-delimited)
PDB CHAIN Start End Fragment
1avq A 171 176 awyfan
1avq A 172 177 wyfany
1c7k A 2 7... (3 Replies)
Hi all,
I've got this question about using cp for copying multiples files from the same source directory to another directory, considering that my working directory ain't the same of the source directory.
Let me give you a simple example what I'm talking about:
Suppose the following files... (2 Replies)
Hi,
IS possible in ksh to make multiples menus?
For example:
My menu.
1)Option1
1.1)Option1.1
2.3)Option1.2
2)Option2
2.1)Option2.1
.
.
.
x)Exit
I've tried with case but no success.
Thanks in advance. (3 Replies)
Hi Guys,
I wonder how can I determine when a given number is a multiple of another one in java. Let's say if I have 27 how can I determine whether is multiple of 5 using java programming. Thanks. (1 Reply)
Hi
My file has a series of rows up to 160 characters in length.
There are 7 columns for each row.
In each row, column 1 starts at position 4
column 2 starts at position 12
column 3 starts at position 43
column 4 starts at position 82
column 5 starts at... (7 Replies)
Ques from newbie
I want to total column X from large number of files, and view totals for each file separately with the filename.
I have tried:
for i in `ls -1 *.pattern`; do cat "$i" | awk '{SUM += $4} END { printf("%8d\t%8d\n", $i,SUM) }'; done
does not work. appreciate your help (5 Replies)
Hi,
I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column).
I want to write a script to join the files by the first common column so that in the... (5 Replies)
i'm trying to optimize my script. i have a lot of instances where i'm doing something like this:
echo $blah | sed 's~ ~|~g' | sed 's-_space_- -g' | sed 's-_LP_-(-g' | sed 's-_RP_-)-g'
obviously, this is very inefficient.
i know i can combine into one sed command with something this, using... (7 Replies)
Hello,
This post is already here but want to do this with another way
Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv:
1|123|jojo
1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies
LEARN ABOUT DEBIAN
rubibtex
rubibtex(1) teTeX rubibtex(1)NAME
rubibtex - make a bibliography for (La)TeX using Russian letters as item names
SYNOPSIS
rubibtex BASENAME
DESCRIPTION
rubibtex is used to run bibtex(1) on auxiliary files with Russian characters in item names (citation keys). It is part of the T2 package.
rubibtex copies the auxiliary file to /tmp, uses sed(1) to convert Cyrillic character commands to their 8-bit ASCII equivalents; runs bib-
tex(1) on the modified file; and finally moves the original auxiliary file back (overwriting the modified file).
rubibtex assumes that the bibtex(1) database (bib) files are encoded with the KOI8-R encoding.
FILES
basename.aux
LaTeX auxiliary file
BUGS
None known, but report any bugs found to the authors.
COPYRIGHT
The T2 package is Copyright 1997-1999 Werner Lemberg, Vladimir Volovich and any individual authors listed elsewhere in package files.
It may be distributed under the conditions of the LaTeX Project Public License, either version 1.1 of this license or (at your option) any
later version.
SEE ALSO bibtex(1), sed(1), <ftp://ftp.vsu.ru/pub/tex/T2/README>.
AUTHOR
Werner Lemberg <wl@gnu.org>, Vladimir Volovich <TeX@vvv.vsu.ru>.
This manual page was written by C.M. Connelly <c@eskimo.com>, for the Debian GNU/Linux system. It may be used by other distributions with-
out contacting the author. Any mistakes or omissions in the manual page are my fault; inquiries about or corrections to this manual page
should be directed to me (and not to the primary author).
teTeX October 2000 rubibtex(1)