Sponsored Content
Top Forums Shell Programming and Scripting Script solution - running Excel macro in SLES Post 302985982 by RudiC on Thursday 17th of November 2016 03:37:58 PM
Old 11-17-2016
Those are not .csv - files. Howsoever, try

Code:
awk '
NR == FNR               {T[$2,$3,$4,$5]
                         next
                        }
FNR == 1                {print "RNA Queue   RNA Operator   RNA WaitTime"
                         next
                        }

($2,$3,$4,$5) in T      {print $12, $13, $14, $16
                        }
' file2 file1
RNA Queue   RNA Operator   RNA WaitTime
2041 Djamila Millien 20000
2041 Djamila Millien 20000
2081 Deidra Wright 20000

This User Gave Thanks to RudiC For This Post:
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

macro on shell script ?

in shifts we used to run a script where in we need to choose from different options. for example the first part would go like this: ======== menu ======== 1)blah 2)blah blah 3)blah blah blah you have chosen: then after that a series of multiple choice so on and so forth...what i would... (4 Replies)
Discussion started by: inquirer
4 Replies

2. Shell Programming and Scripting

How to launch a Csh shell script using Excel Macro ?

Hi all. I need to use excel macro at my desktop to launch a csh script which is in a solaris environment. What is the code that i can use in macro to help me with that ? Basically, the code need to telnet or ftp to the solaris environment and just run the script and the macro will output in an... (1 Reply)
Discussion started by: Raynon
1 Replies

3. Programming

Make-question - redefine a macro, using another macro..?

I think there is no problem to use any macro in a new macro definishion, but I have a problem with that. I can not understand why? I have a *.mak file that inludes file with many definitions and rules. ############################################## include dstndflt.mak ... One of the... (2 Replies)
Discussion started by: alex_5161
2 Replies

4. SuSE

SLES 9 vs SLES 11 hard drive cache read timings are diffrent

Can anyone give me a little clue on why the hard drive cache read timings on sles 9 is better then sles 11? The same hardware was used in both test. I even deleted the ata_generic module from initrd. The speed difference is 10MB vs 5 MB Thanks (1 Reply)
Discussion started by: 3junior
1 Replies

5. Shell Programming and Scripting

Invoke a script in UNIX using Excel Macro

Hi, I am using Send Keys to connect to UNIX server and invoke a script . Is there an alternate way to connect to UNIX server using Excel macro and invoke a UNIX Shell script? Anu (2 Replies)
Discussion started by: anandita.jha
2 Replies

6. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

7. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

8. Shell Programming and Scripting

Converting macro to bash script

Gents, Please can you help me with this. When column 49 == 2 Before X 4714 14710 69445.00 19257.001 1218 12271 69596.00 19460.00 19478.001 X 4714 14710 69445.00 19257.001 1228 12292 69596.00 19480.00 19480.001 After X 4714 14710 69445.00 19257.001 1218... (1 Reply)
Discussion started by: jiam912
1 Replies
Bio::Variation::RNAChange(3pm)				User Contributed Perl Documentation			    Bio::Variation::RNAChange(3pm)

NAME
Bio::Variation::RNAChange - Sequence change class for RNA level SYNOPSIS
$rnachange = Bio::Variation::RNAChange->new ('-start' => $start, '-end' => $end, '-length' => $len, '-codon_pos' => $cp, '-upStreamSeq' => $upflank, '-dnStreamSeq' => $dnflank, '-proof' => $proof, '-isMutation' => 1, '-mut_number' => $mut_number ); $a1 = Bio::Variation::Allele->new; $a1->seq('a'); $rnachange->allele_ori($a1); my $a2 = Bio::Variation::Allele->new; $a2->seq('t'); $rnachange->add_Allele($a2); $rnachange->allele_mut($a2); print "The codon change is ", $rnachange->codon_ori, ">", $rnachange->codon_mut, " "; # add it to a SeqDiff container object $seqdiff->add_Variant($rnachange); # and create links to and from DNA level mutation objects $rnachange->DNAMutation($dnamut); $dnamut->RNAChange($rnachange); DESCRIPTION
The instantiable class Bio::Variation::DNAMutation describes basic sequence changes at RNA molecule level. It uses methods defined in superclass Bio::Variation::VariantI. See Bio::Variation::VariantI for details. You are normally expected to create a corresponding Bio::Variation::DNAMutation object even if mutation is defined at RNA level. The numbering follows then cDNA numbering. Link the DNAMutation object to the RNAChange object using the method DNAMutation(). If the variation described by a RNAChange object is translated, link the corresponding Bio::Variation::AAChange object to it using method AAChange(). See Bio::Variation::DNAMutation and Bio::Variation::AAChange for more information. FEEDBACK
Mailing Lists User feedback is an integral part of the evolution of this and other Bioperl modules. Send your comments and suggestions preferably to the Bioperl mailing lists Your participation is much appreciated. bioperl-l@bioperl.org - General discussion http://bioperl.org/wiki/Mailing_lists - About the mailing lists Support Please direct usage questions or support issues to the mailing list: bioperl-l@bioperl.org rather than to the module maintainer directly. Many experienced and reponsive experts will be able look at the problem and quickly address it. Please include a thorough description of the problem with code and data examples if at all possible. Reporting Bugs Report bugs to the Bioperl bug tracking system to help us keep track the bugs and their resolution. Bug reports can be submitted via the web: https://redmine.open-bio.org/projects/bioperl/ AUTHOR - Heikki Lehvaslaiho Email: heikki-at-bioperl-dot-org APPENDIX
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _ codon_ori Title : codon_ori Usage : $obj->codon_ori(); Function: Sets and returns codon_ori triplet. If value is not set, creates the codon triplet from the codon position and flanking sequences. The string has to be three characters long. The character content is not checked. Example : Returns : string Args : string codon_mut Title : codon_mut Usage : $obj->codon_mut(); Function: Sets and returns codon_mut triplet. If value is not set, creates the codon triplet from the codon position and flanking sequences. Return undef for other than point mutations. Example : Returns : string Args : string codon_pos Title : codon_pos Usage : $obj->codon_pos(); Function: Sets and returns the position of the mutation start in the codon. If value is not set, returns false. Example : Returns : 1,2,3 Args : none if get, the new value if set codon_table Title : codon_table Usage : $obj->codon_table(); Function: Sets and returns the codon table id of the RNA If value is not set, returns 1, 'universal' code, as the default. Example : Returns : integer Args : none if get, the new value if set DNAMutation Title : DNAMutation Usage : $mutobj = $obj->DNAMutation; : $mutobj = $obj->DNAMutation($objref); Function: Returns or sets the link-reference to a mutation/change object. If there is no link, it will return undef Returns : an obj_ref or undef AAChange Title : AAChange Usage : $mutobj = $obj->AAChange; : $mutobj = $obj->AAChange($objref); Function: Returns or sets the link-reference to a mutation/change object. If there is no link, it will return undef Returns : an obj_ref or undef exons_modified Title : exons_modified Usage : $modified = $obj->exons_modified; : $modified = $obj->exons_modified(1); Function: Returns or sets information (example: a simple boolean flag) about the modification of exons as a result of a mutation. region Title : region Usage : $obj->region(); Function: Sets and returns the name of the sequence region type or protein domain at this location. If value is not set, returns false. Example : Returns : string Args : string cds_end Title : cds_end Usage : $cds_end = $obj->get_cds_end(); Function: Sets or returns the cds_end from the beginning of the DNA sequence to the coordinate start used to describe variants. Should be the location of the last nucleotide of the terminator codon of the gene. Example : Returns : value of cds_end, a scalar Args : label Title : label Usage : $obj->label(); Function: Sets and returns mutation event label(s). If value is not set, or no argument is given returns false. Each instantiable subclass of L<Bio::Variation::VariantI> needs to implement this method. Valid values are listed in 'Mutation event controlled vocabulary' in http://www.ebi.ac.uk/mutations/recommendations/mutevent.html. Example : Returns : string Args : string _change_codon_pos Title : _change_codon_pos Usage : $newCodonPos = _change_codon_pos($myCodonPos, 5) Function: Keeps track of the codon position in a changeing sequence Returns : codon_pos = integer 1, 2 or 3 Args : valid codon position signed integer offset to a new location in sequence perl v5.14.2 2012-03-02 Bio::Variation::RNAChange(3pm)
All times are GMT -4. The time now is 04:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy