12-31-2007
A quick fix :-) Hope this works
$ cat fil1
LEO oracle engineer 210375
P.Jones Office Runner ID897
L.Clip Personl Chief ID982
S.Round UNIX admin ID6
$ cat fil2
Dept2C ID897 6 years
Dept5Z ID982 1 year
Dept3S ID6 2 years
GEDA 210375 1 year
$ sort +3 -4 fil1 > fil1.tmp
$ sort +1 -2 fil2 > fil2.tmp
$ join -1 4 -2 2 fil1.tmp fil2.tmp
210375 LEO oracle engineer GEDA 1 year
ID6 S.Round UNIX admin Dept3S 2 years
ID897 P.Jones Office Runner Dept2C 6 years
ID982 L.Clip Personl Chief Dept5Z 1 year
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am trying to join 2 files..viz
f1:
12~a1
13~a2
112~a3
1112~a4
f2:
12~fa2
13~fa2
112~fa3
1112~fa4
while I join..I just get 2 o/p..
12~a1~fa2
13~a2~fa2 (4 Replies)
Discussion started by: unisam
4 Replies
2. Shell Programming and Scripting
Dear Experts,
I have several (say 'm') text files, each with 'n' columns. I want to put them into a large single file with n*m columns.
a 1 a 1 a 1 a 1
b 2 b 5 b 1 b 3
c 3 c 7 ... (1 Reply)
Discussion started by: Mish_99
1 Replies
3. Shell Programming and Scripting
All,
I have 3 files (tab seperated):
Note: Please treat dash (-) as empty value in the file, I have added it to make input easily readable
file1: (2 cols)
A 1
B 2
C 3
file2: (4 cols - col4 has empty values for 4th column except 2nd row)
A 1 5 -
B 2 6 Y
C 3 7 -
D 4 8 -
file3... (1 Reply)
Discussion started by: bgmmk
1 Replies
4. Programming
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)
Discussion started by: robbiezr
0 Replies
5. Shell Programming and Scripting
I am given:
Sara:Smith:11234:3:63498:25:40
Perry:Potter:12445:2:35664:15:40
Ann:Abbott:23323:2:54865:22:42
Maple:Myers:24223:1:63498:18:35
Harold:Hanson:35664:2:54865:10:40
Bob:Brown:40778:1:24223:15:40
Jane:Jones:41288:1:53498:24:40
Wanda:Wallace:51122:4:63498:55:40... (4 Replies)
Discussion started by: ehshi1992
4 Replies
6. UNIX for Dummies Questions & Answers
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)
Discussion started by: InfoSeeker
3 Replies
7. UNIX for Dummies Questions & Answers
file1:
Toronto:12439755:1076359:July 1, 1867:6
Quebec City:7560592:1542056:July 1, 1867:5
Halifax:938134:55284:July 1, 1867:4
Fredericton:751400:72908:July 1, 1867:3
Winnipeg:1170300:647797:July 15, 1870:7
Victoria:4168123:944735:July 20, 1871:10
Charlottetown:137900:5660:July 1, 1873:2... (2 Replies)
Discussion started by: mindfreak
2 Replies
8. UNIX for Dummies Questions & Answers
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)
Discussion started by: evelibertine
5 Replies
9. UNIX for Beginners Questions & Answers
i've tried every variation possible and keep getting not sorted error. can anyone shed any light on how to do this?
(image attached) (1 Reply)
Discussion started by: deadcick
1 Replies
10. Shell Programming and Scripting
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 PHP
easter_days
EASTER_DAYS(3) 1 EASTER_DAYS(3)
easter_days - Get number of days after March 21 on which Easter falls for a given year
SYNOPSIS
int easter_days ([int $year = date("Y")], [int $method = CAL_EASTER_DEFAULT])
DESCRIPTION
Returns the number of days after March 21 on which Easter falls for a given year. If no year is specified, the current year is assumed.
This function can be used instead of easter_date(3) to calculate Easter for years which fall outside the range of Unix timestamps (i.e.
before 1970 or after 2037).
The date of Easter Day was defined by the Council of Nicaea in AD325 as the Sunday after the first full moon which falls on or after the
Spring Equinox. The Equinox is assumed to always fall on 21st March, so the calculation reduces to determining the date of the full moon
and the date of the following Sunday. The algorithm used here was introduced around the year 532 by Dionysius Exiguus. Under the Julian
Calendar (for years before 1753) a simple 19-year cycle is used to track the phases of the Moon. Under the Gregorian Calendar (for years
after 1753 - devised by Clavius and Lilius, and introduced by Pope Gregory XIII in October 1582, and into Britain and its then colonies in
September 1752) two correction factors are added to make the cycle more accurate.
PARAMETERS
o $year
- The year as a positive number. If omitted, defaults to the current year according to the local time.
o $method
- Allows Easter dates to be calculated based on the Gregorian calendar during the years 1582 - 1752 when set to CAL_EASTER_ROMAN.
See the calendar constants for more valid constants.
RETURN VALUES
The number of days after March 21st that the Easter Sunday is in the given $year.
EXAMPLES
Example #1
easter_days(3) example
<?php
echo easter_days(1999); // 14, i.e. April 4
echo easter_days(1492); // 32, i.e. April 22
echo easter_days(1913); // 2, i.e. March 23
?>
SEE ALSO
easter_date(3).
PHP Documentation Group EASTER_DAYS(3)