07-14-2011
i need to transfer the data from a flatfile to excel.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
2. Shell Programming and Scripting
Hi,
I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets.
Can anyone suggest ways to do this in UNIX ?
Thanks,
David. (2 Replies)
Discussion started by: libin4u2000
2 Replies
3. Shell Programming and Scripting
Hi,
I Have a directory(views) and i have 100 .sql files in the same directory.
I need to be add 8 rows in each file.
The format 8 rows has like:
grant select on file_name to User1
/
grant select on file_name to User2
/
grant select on file_name to User3
/
grant select on file_name to... (1 Reply)
Discussion started by: koti_rama
1 Replies
4. Shell Programming and Scripting
Hi Friends,
How to add if data is in different rows.
Input:
1;20091102;20170930;-9.00;|
1;20091026;20170930;-2.00;|
1;20100720;20170930;-25.00;|
1;20090901;20211227;-10.00;|
Output
9+2+25+10 = 46
Thx
Suresh (4 Replies)
Discussion started by: suresh3566
4 Replies
5. Shell Programming and Scripting
i need to write script to copy the txt file to excel. (data can be 2000+), data may not be in order
ex:
my name: abc
age: 20
add: xyz
DOB: 17-mar-2010
add1: adf
add2: guioth
my name: cat
age: 35
DOB: 11-oct-2005
city: yeshjl
add: opq
DOB: 17-mar-2010
add1: atg
add2: gth
add3:ert
... (2 Replies)
Discussion started by: pjain
2 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
i have an excel sheet as below:
day
-----
monday
tuesday
wenesday
thursday
friday
i need to append the two more columns in this existing file below:
insert date should be todays date---
day insert date insert user
---- ---------- ... (3 Replies)
Discussion started by: arunmanas
3 Replies
7. Shell Programming and Scripting
Hi,
Would anyone be able to tell me how to check the number of rows in an excel sheet on unix box, please?
Cheers,
Girish. (2 Replies)
Discussion started by: girish1428
2 Replies
8. Shell Programming and Scripting
Hi,
Is there a way to find the count of number of rows of a.txt please? Where a.txt is as follows:
/usr/bin/uuencode /tmp/a.csv a.csv > /tmp/a.txt
#a.csv is a comma separated variable file
Cheers,
Girish. (7 Replies)
Discussion started by: girish1428
7 Replies
9. Shell Programming and Scripting
I am working on an assignment to pull all the records from excel sheet programatically and use the data for further calculations.
In this process, I first defined 10 records in excel sheet and executed the below code.
In the first run it is OK. But after deleting last few rows in excel sheet and... (0 Replies)
Discussion started by: giridhar276
0 Replies
10. Shell Programming and Scripting
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
LEARN ABOUT DEBIAN
psequin
PSEQUIN(1) NCBI Tools User's Manual PSEQUIN(1)
NAME
Psequin - submit sequences to Genbank, EMBL, and DDBJ
SYNOPSIS
Psequin [-b] [-bse] [-e] [-f filename] [-gc] [-h] [-oldaln] [-oldasn] [-oldgph] [-oldseq] [-oldsource] [-s] [-w] [-x]
DESCRIPTION
Psequin is a program designed to aid in the submission of sequences to the GenBank, EMBL, and DDBJ sequence databases. It was written at
the National Center for Biotechnology Information, part of the National Library of Medicine at the National Institutes of Health.
Psequin can assemble the essential elements of a GenBank record from simple FASTA-format text files. For example, the program obtains the
proper genetic code from an organism name, and automatically determines coding region intervals by back-translation from the protein
sequence. An on-line help window scrolls to the appropriate place as the user moves between and within data entry forms, giving relevant
details on what information is expected.
Psequin also contains a number of built-in validation functions for quality assurance. Features such as splice sites and coding region
translations are checked for accuracy or internal consistency. Double-clicking on an error message launches an appropriate editor by which
the user can correct any problems.
Psequin provides live, clickable views of the data in a variety of formats, including a report form, GenBank flatfile, EMBL flatfile, and a
graphical view. Double clicking on an item in any of these formats launches an editor for that item. The editor is capable of maintaining
correct feature table positions as the underlying sequence is edited. It can display features on the sequence during editing, and allows
feature intervals to be adjusted by direct manipulation.
OPTIONS
-b Bioseq-set mode
-bse binseqentry mode
-e Entrez mode
-f filename
read from filename
-gc genome center mode
-h turn off automatic help
-oldaln
use old alignment reader
-oldasn
leave as old ASN.1
-oldgph
use old graphic view
-oldseq
use old sequence view
-oldsource
use old flat-file source format
-s subtool mode
-w workbench mode
-x read from standard input
AUTHOR
The National Center for Biotechnology Information.
SEE ALSO
asnmacro(1), sbtedit(1), tbl2asn(1), /usr/share/doc/ncbi-tools-x11/sequin.htm, <http://www.ncbi.nlm.nih.gov/Sequin/>.
NCBI
2011-09-02 PSEQUIN(1)