Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Connecting 3 files
Top Forums Shell Programming and Scripting Connecting 3 files Post 302876761 by newbie83 on Tuesday 26th of November 2013 01:03:00 PM
Old 11-26-2013
Connecting 3 files
Hi,

I`m trying to do functional categorization of a species and I need to join 3 files for that. I want to look up the code for each record in file 3 in file 1 ,
code indicated within brackets[] for example OR is the code forAt1g31340, J is the code for At1g53930.

Then I would like to find the description of the code from file 2.
The R in any code can be ignored unless it is [R] itself.
For example [OR], [JR] should be treated as [O] and [J] but [R] is treated as [R].

Actual File 1 is downloaded from ftp://ftp.ncbi.nlm.nih.gov/pub/COG/KOG/kog . I have attached a subset for testing (inline text messing up formatting)

Actual File 2 is downloaded from ftp://ftp.ncbi.nlm.nih.gov/pub/COG/KOG/fun.txt . I have attached for testing. (inline text messing up formatting)

File 3 is a list of ids to be searched
Code:
At1g53930
At2g36170

Expected output with a pipe (|) delimiter
Code:
At1g53930|O|Posttranslational modification, protein turnover, chaperones| CELLULAR PROCESSES AND SIGNALING
At2g36170|J|Translation, ribosomal structure and biogenesis| INFORMATION STORAGE AND PROCESSING

file1.txt (184 Bytes) 
file2.txt (1.1 KB) 
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

connecting ....sql

if; sqlplus /nolog <<EOF conn / as sysdba spool /tmp/start.out @/oracle/home/start.sql spool off exit EOF fi For this code i am getting error: Test.sh: syntax error at line 7 : `<<' unmatched (8 Replies)
Discussion started by: dreams5617
8 Replies

2. UNIX for Dummies Questions & Answers

connecting the ip address

Hi, I have three ip address say x.x.x.x , y.y.y.y and z.z.z.z I am connecting to x.x.x.x first and from there i am telnet y.y.y.y and getting into y and from there i am telnet to z i want to know, can we write a script, which can automatically connect from x to y and from y to z.. is... (1 Reply)
Discussion started by: vasikaran
1 Replies

3. Solaris

Connecting to SAN

I am about to attempt to connect my sun 280R boxes to a EMC SAN. I have Qlogic cards that came from Sun. I am going to load traffic manager, navisphere client. what else do i need, sun foundation suite ro somehting? This is the first time ive ever connected to a SAN. any help would be... (3 Replies)
Discussion started by: BG_JrAdmin
3 Replies

4. AIX

Connecting to DB

Is it possible to connect to two databases in a single query with different username and passwords? provide an example pls (1 Reply)
Discussion started by: rollthecoin
1 Replies

5. UNIX for Dummies Questions & Answers

Connecting to website

Okay, here's the situation: I have a UNIX box hosting a website. The website is basically there to hold a .swf file; when you go to the URL, the .swf file loads, and it pulls data from a database on another computer into a cache. The cache holds things for 24 hours. This all works fine, so it's... (7 Replies)
Discussion started by: BSchow
7 Replies

6. UNIX for Dummies Questions & Answers

Connecting Two Unix Computers To Share Files

I was wondering if I could get some help with two of my Unix computers. Bare with me as I am new to this software and, hardly know anything on these computers, except based on what I have already worked with them. Here is my issue. I have two unix computers setup together, not connected... (6 Replies)
Discussion started by: OrangeNblack
6 Replies

7. UNIX for Dummies Questions & Answers

connecting lines of 2 different files

How would i connect the lines of 2 different files? Also how would i reissue the command to use an equal signsas the seperators between the fields? (1 Reply)
Discussion started by: trob
1 Replies

8. Shell Programming and Scripting

connecting through sqlplus

I am trying to connect to one of the oracle sever using uni through sqlplus command: sqlplus -s BOXI_ALPH_AUDITOR,Q078_audit$@Q047 But its not getting connected. I tried using some different server using same syntax its working. What differene i found is the password is having no special... (2 Replies)
Discussion started by: gander_ss
2 Replies

9. Shell Programming and Scripting

Error when connecting to remote server to find files with timestamp today's day

I am connecting to remote server and try to check if files with timestamp as Today's day are on the directory. Below is my code TARFILE=${NAME}.tar TARGZFILE=${NAME}.tar.gz ssh ${DESTSERVNAME} 'cd /export/home/iciprod/download/let/monthly; Today=`date +%Y%m%d`; if ;then echo "We... (1 Reply)
Discussion started by: digioleg54
1 Replies

10. Shell Programming and Scripting

Shell script for connecting multiple servers and then copying 30 days old files

Shell script for connecting multiple servers and then copying 30 days old files from those server . HI , I have 6 multiple servers pla1,pla2,pla3,pla4,pla5,pla6 1. These six servers have common shared mount point /var/share 2. Running script from /var/share to connect these servers.I... (1 Reply)
Discussion started by: rcroyal88
1 Replies

LEARN ABOUT REDHAT

samba

SAMBA(7)																  SAMBA(7)

NAME

       SAMBA - A Windows SMB/CIFS fileserver for UNIX

SYNOPSIS

       Samba

DESCRIPTION

       The  Samba  software  suite is a collection of programs that implements the Server Message Block (commonly abbreviated as SMB) protocol for
       UNIX systems. This protocol is sometimes also referred to as the Common Internet File System (CIFS), LanManager or NetBIOS protocol.

       smbd   The smbd daemon provides the file and print services to SMB clients, such as Windows 95/98, Windows NT, Windows  for  Workgroups	or
	      LanManager. The configuration file for this daemon is described in smb.conf

       nmbd   The nmbd daemon provides NetBIOS nameserving and browsing support. The configuration file for this daemon is described in smb.conf

       smbclient
	      The smbclient program implements a simple ftp-like client. This is useful for accessing SMB shares on other compatible servers (such
	      as Windows NT), and can also be used to allow a UNIX box to print to a printer attached to any SMB server (such as a PC running Win-
	      dows NT).

       testparm
	      The testparm utility is a simple syntax checker for Samba's smb.confconfiguration file.

       testprns
	      The testprns utility supports testing printer names defined in your printcap> file used by Samba.

       smbstatus
	      The smbstatus tool provides access to information about the current connections to smbd.

       nmblookup
	      The nmblookup tools allows NetBIOS name queries to be made from a UNIX host.

       make_smbcodepage
	      The make_smbcodepage utility provides a means of creating SMB code page definition files for your smbd server.

       smbpasswd
	      The smbpasswd command is a tool for changing LanMan and Windows NT password hashes on Samba and Windows NT servers.

COMPONENTS

       The  Samba  suite  is made up of several components. Each component is described in a separate manual page. It is strongly recommended that
       you read the documentation that comes with Samba and the manual pages of those components that you use. If the manual  pages  aren't  clear
       enough then please send a patch or bug report to  samba@samba.org <URL:mailto:samba@samba.org>

AVAILABILITY

       The  Samba  software  suite  is licensed under the GNU Public License(GPL). A copy of that license should have come with the package in the
       file COPYING. You are encouraged to distribute copies of the Samba suite, but please obey the terms of this license.

       The latest version of the Samba suite can be obtained via anonymous ftp from samba.org in the directory pub/samba/. It is also available on
       several mirror sites worldwide.

       You  may  also  find useful information about Samba on the newsgroup  comp.protocol.smb <URL:news:comp.protocols.smb> and the Samba mailing
       list. Details on how to join the mailing list are given in the README file that comes with Samba.

       If you have access to a WWW viewer (such as Netscape or Mosaic) then you will also find lots of useful information, including  back  issues
       of the Samba mailing list, at http://lists.samba.org <URL:http://lists.samba.org/>.

VERSION

       This man page is correct for version 2.2 of the Samba suite.

CONTRIBUTIONS

       If  you	wish  to  contribute  to  the  Samba  project,	then  I  suggest  you  join  the  Samba  mailing  list	at  http://lists.samba.org
       <URL:http://lists.samba.org/>.

       If you have patches to submit or bugs to report then you may mail them directly to samba-patches@samba.org.  Note, however, that due to the
       enormous popularity of this package the Samba Team may take some time to respond to mail. We prefer patches in diff -u format.

CONTRIBUTORS

       Contributors to the project are now too numerous to mention here but all deserve the thanks of all Samba users. To see a full list, look at
       ftp://samba.org/pub/samba/alpha/change-log   <URL:ftp://samba.org/pub/samba/alpha/change-log>   for   the   pre-CVS    changes	 and	at
       ftp://samba.org/pub/samba/alpha/cvs.log	<URL:ftp://samba.org/pub/samba/alpha/cvs.log>  for  the contributors to Samba post-CVS. CVS is the
       Open Source source code control system used by the Samba Team to develop Samba. The project would have been unmanageable without it.

       In addition, several commercial organizations now help fund the Samba Team with money and equipment. For details see the Samba Web pages at
       http://samba.org/samba/samba-thanks.html

AUTHOR

       The  original  Samba  software  and  related utilities were created by Andrew Tridgell. Samba is now developed by the Samba Team as an Open
       Source project similar to the way the Linux kernel is developed.

       The original Samba man pages were written by Karl Auer.	The man page sources were converted to YODL format  (another  excellent  piece	of
       Open  Source  software,	available  at ftp://ftp.icce.rug.nl/pub/unix/ <URL:ftp://ftp.icce.rug.nl/pub/unix/>) and updated for the Samba 2.0
       release by Jeremy Allison. The conversion to DocBook for Samba 2.2 was done by Gerald Carter

								 19 November 2002							  SAMBA(7)
All times are GMT -4. The time now is 05:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy