02-24-2006
comparing within text files
hi!
some looping problem here...
i have a 2-column text file
4835021 20060903FAL0132006
4835021 20060904FAL0132006
4835021 20060905FAL0132006
4835023 20060903FAL0132006
4835023 20061001HAL0132006
4835023 20061002HAL0132006
4835088 20061002HAL0132006
4835099 20061002HAL0132006
what i would like to do is to arrange this to (below)
4835021 with earliest date
4835023 with earliest date
4835033 with earliest date
4835088 with earliest date
4835099 with earliest date
i would like to know which proper commands should i use.
thanks!
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am comparing text files where there are number of rows of numbers from window to unix box
Is there any way of checking lets say 4 document of text file
and seeing the difference only (or missing rows of numbers)
with simple commands with lets say a batch file
FROM ABSOULTE... (2 Replies)
Discussion started by: sjumma
2 Replies
2. UNIX for Dummies Questions & Answers
Hi Guys,
How can I compare 2 text files and show the differences between the 2 files but have some of the text ignored?
Example
File1 File2
Thomas Thomass !1st name!
David Davidd !2nd name!
John John !3rd name!
So,... (1 Reply)
Discussion started by: jimmyflip
1 Replies
3. Shell Programming and Scripting
Hi all,
I have got a problem while comparing 2 text files and the result should contains the unique values(Non repeatable).
For eg:
file1.txt
1
2
3
4
file2.txt
2
3
So after comaping the above 2 files I should get only 1 and 4 as the output. Pls help me out. (7 Replies)
Discussion started by: smarty86
7 Replies
4. Shell Programming and Scripting
Hi All,
I have two files of the following formats
file 1 - this is a big file
>AB_1 gi|229194403|ref|ZP_04321208.1| group II intron reverse transcriptase/maturase
gdfjafhlkhlnlklaklskckcfhhahgfahajfkkallalfafafa
>AB_2 gi|229194404|ref|ZP_04321209.1|
gfksjgfkjsfjslfslfslhf
>AB_3... (1 Reply)
Discussion started by: Lucky Ali
1 Replies
5. Shell Programming and Scripting
I have this 2 files:
k5login
sanwar@systems.nyfix.com
jjamnik@systems.nyfix.com
nisha@SYSTEMS.NYFIX.COM
rdpena@SYSTEMS.NYFIX.COM
service/backups-ora@SYSTEMS.NYFIX.COM
ivanr@SYSTEMS.NYFIX.COM
nasapova@SYSTEMS.NYFIX.COM
tpulay@SYSTEMS.NYFIX.COM
rsueno@SYSTEMS.NYFIX.COM... (11 Replies)
Discussion started by: linuxgeek
11 Replies
6. Shell Programming and Scripting
RHEL 5.4 (Korn shell)
I have two files
First file
$ cat myfile_1.txt
JOHN
KEITH
CHANG
JUDE
CHRISTINE
KRISHNA
AHMED
ULRICH
JESSICA-- Second file has 3 names missing (AHMED, ULRICH, JESSICA )
$ cat myfile_2.txt
JOHN
KEITH
CHANG
JUDE
CHRISTINE (4 Replies)
Discussion started by: John K
4 Replies
7. UNIX for Dummies Questions & Answers
Hey everybody,
I am new here and already a question to ask, I just recently started some bioinformatic work for my PhD so I am slowly learning
Anyway, here is my problem, I have two text files, one contains the complete data file with 43000 genes and their read counts for all my samples... (1 Reply)
Discussion started by: ant55
1 Replies
8. Shell Programming and Scripting
Hi All,
I have 2 files like below
vi f1
frog
elephant
rabit
zebra
dog
vi f2
rabit
dog
==============
Now i want to comapre two files and the result will be
frog (8 Replies)
Discussion started by: kumar85shiv
8 Replies
9. Shell Programming and Scripting
Hi
i have 2 files
file1.txt
XX,ZZ,XC,EE,RR,BB
XC,CF,FG,RG,GH,GH
File2.txt
DF,GH,MH,FR,FG,GH,NOTOK
XX,ZZ,XC,EE,RR,BB,OK
result
XX,ZZ,XC,EE,RR,BB OK
look for column1 , XX and if it matches in File2.txt , retrieve the 7 th field from File2 and print in 3 rd file , ... (9 Replies)
Discussion started by: Shyam_84
9 Replies
LEARN ABOUT CENTOS
function::ctime
FUNCTION::CTIME(3stap) Time utility functions FUNCTION::CTIME(3stap)
NAME
function::ctime - Convert seconds since epoch into human readable date/time string
SYNOPSIS
ctime:string(epochsecs:long)
ARGUMENTS
epochsecs
Number of seconds since epoch (as returned by gettimeofday_s)
DESCRIPTION
Takes an argument of seconds since the epoch as returned by gettimeofday_s. Returns a string of the form
"Wed Jun 30 21:49:08 1993"
The string will always be exactly 24 characters. If the time would be unreasonable far in the past (before what can be represented with a
32 bit offset in seconds from the epoch) an error will occur (which can be avoided with try/catch). If the time would be unreasonable far
in the future, an error will also occur.
Note that the epoch (zero) corresponds to
"Thu Jan 1 00:00:00 1970"
The earliest full date given by ctime, corresponding to epochsecs -2147483648 is "Fri Dec 13 20:45:52 1901". The latest full date given by
ctime, corresponding to epochsecs 2147483647 is "Tue Jan 19 03:14:07 2038".
The abbreviations for the days of the week are 'Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', and 'Sat'. The abbreviations for the months are
'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', and 'Dec'.
Note that the real C library ctime function puts a newline ('
') character at the end of the string that this function does not. Also note
that since the kernel has no concept of timezones, the returned time is always in GMT.
SystemTap Tapset Reference June 2014 FUNCTION::CTIME(3stap)