03-05-2016
The compatibility of compression when transferring data between different operating systems always needs to be tested and never taken for granted.
What Unix OS is it? What version of Windows is it?
I assume that you have tested the processing of the data by transferring a file (by whatever means, FTP, USB stick, whatever) to ensure compatibility of the uncompressed file and you know that works?
So then you want to compress the data to improve speed. From experience I have found that often just using the 'compress' command on Unix (again depending which version), transferring that to Windows, and then using the vanilla unzip often works.
My advice is that if the decompression operation fails try a different utility. Looking at your post, have you tried 'winrar' to unzip the file? If that doesn't work try another unzip utility.
So no stock answer I'm afraid. Just keep testing until you find compatibility.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
Im trying to extract a portion of a big file.
Using unique pattern /occurrence ,
(ex. loginname1,logoff and loginname2,logoff ),
I like to print the lines that contain the patterns and the lines between them.
Also, create a file for every login occurrence.
Thanks for everyone's... (1 Reply)
Discussion started by: apalex
1 Replies
2. Shell Programming and Scripting
Hi, everyone,
Now I have a ".csv" file and I want to extract a string-like date value from the file, say, it is in the 2nd row of the file and it is in the fixed context like:
"
This is the file title, //Row 1
The lastest update happened on: 10-Mar-2006 //Row2
....//other irrelavent rows
"... (6 Replies)
Discussion started by: homer_hn
6 Replies
3. Shell Programming and Scripting
Dear Members,
I have a huge file generated by the command 'whois' for hundred of IPs. Each section in the file starts with
I want to extract those lines which start with any of these words: Input:
OrgName: University of C
OrgID: U1
Address: OIT
Address: NH
City: ... (5 Replies)
Discussion started by: srsahu75
5 Replies
4. UNIX for Dummies Questions & Answers
Hi all,
I'm new in the unix environment. I'm having a challenge in extracting data from a flat file and convert it to a CSV file format or I should be able to open it with MS Excel.
The input data in my flat file looks like this:
AV00001001155000063637143326711145412082EM SITHOLE... (3 Replies)
Discussion started by: Mthimbana
3 Replies
5. Shell Programming and Scripting
Hi All,
I have a requirement where I have to search the file with some text say "Exception". This exception word can be repeated for more then 10 times.
Suppose the "Exception" word is repeated at line numbers say x=10, 50, 60, 120. Now I want to extract all the lines starting from x-5 to... (3 Replies)
Discussion started by: rrangaraju
3 Replies
6. Shell Programming and Scripting
Hello everybody,
Here is my problem : I cannot find a way to extract data from a particular file and more precisely I cannot extract the result of my awk script to an external file because I am currently working on HP-UX.
I would like a simple script (without awk) which asks for a date like... (4 Replies)
Discussion started by: freyr
4 Replies
7. Shell Programming and Scripting
Hi,
I have three files as below:
AA.DAT20110505063903.Z
AA.DAT20110405062903.Z
AA.DAT20110305061903.Z
All the above files are appended with Date and timestamp in compressed format.
I need to extract AA.DAT20110505063903.Z(which is the latest file) from one server and uncompress it... (2 Replies)
Discussion started by: pyaranoid
2 Replies
8. Shell Programming and Scripting
I need to extract some content of a file.
Example
file abc
vi abc
ooooooooo
bbbbbbbbb
vvv 1234 5
vvv 6789 3
xxxxxxxxxx
xxxxxxxxxx
i want to extract only the following content from file abc and store in another file say temp.
1234 5
6789 3
what should be my approach? (2 Replies)
Discussion started by: priya_ag04
2 Replies
9. Shell Programming and Scripting
Hi Freinds,
I have a file1.txt in the following format
File1.txt
I want to get 2 files from the above file filextra.txt should have the lines which are ending with "<" and remaining lines in the filecompare.txt file.
Please help. (3 Replies)
Discussion started by: i150371485
3 Replies
10. Shell Programming and Scripting
FILE_ID extraction from file name and save it in CSV file after looping through each folders
My files are located in UNIX Server, i want to extract file_id and file_name from each file .and save it in a CSV file. How do I do that?
I have folders in unix environment, directory structure is... (15 Replies)
Discussion started by: princetd001
15 Replies
LEARN ABOUT DEBIAN
bio::seqio::excel
Bio::SeqIO::excel(3pm) User Contributed Perl Documentation Bio::SeqIO::excel(3pm)
NAME
Bio::SeqIO::excel - sequence input/output stream from a
MSExcel-formatted table
SYNOPSIS
#It is probably best not to use this object directly, but
#rather go through the SeqIO handler system. Go:
$stream = Bio::SeqIO->new(-file => $filename, -format => 'excel');
while ( my $seq = $stream->next_seq() ) {
# do something with $seq
}
DESCRIPTION
This class transforms records in a MS Excel workbook file into Bio::Seq objects. It is derived from the table format module and merely
defines additional properties and overrides the way to get data from the file and advance to the next record.
The module permits specifying which columns hold which type of annotation. The semantics of certain attributes, if present, are pre-
defined, e.g., accession number and sequence. Additional attributes may be added to the annotation bundle. See Bio::SeqIO::table for a
complete list of parameters and capabilities.
You may also specify the worksheet from which to obtain the data, and after finishing one worksheet you may change the name to keep reading
from another worksheet (in the same file).
This module depends on Spreadsheet::ParseExcel to parse the underlying Excel file.
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 one
of 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 email or the web:
https://redmine.open-bio.org/projects/bioperl/
AUTHOR - Hilmar Lapp
Email hlapp at gmx.net
APPENDIX
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _
new
Title : new
Usage : $stream = Bio::SeqIO->new(-file => $filename, -format => 'excel')
Function: Returns a new seqstream
Returns : A Bio::SeqIO stream for a MS Excel format
Args : Supports the same named parameters as Bio::SeqIO::table,
except -delim, which obviously does not apply to a binary
format. In addition, the following parameters are supported.
-worksheet the name of the worksheet holding the table;
if unspecified the first worksheet will be
used
worksheet
Title : worksheet
Usage : $obj->worksheet($newval)
Function: Get/set the name of the worksheet holding the table. The
worksheet name may also be a numeric index.
You may change the value during parsing at any time in
order to start reading from a different worksheet (in the
same file).
Example :
Returns : value of worksheet (a scalar)
Args : on set, new value (a scalar or undef, optional)
close
Title : close
Usage :
Function: Close and/or release the resources used by this parser instance.
We override this here in order to free up the worksheet and
other related objects.
Example :
Returns :
Args :
Internal methods
All methods with a leading underscore are not meant to be part of the 'official' API. They are for use by this module only, consider them
private unless you are a developer trying to modify this module.
_worksheet
Title : _worksheet
Usage : $obj->_worksheet($newval)
Function: Get/set the worksheet object to be used for accessing cells.
Example :
Returns : value of _worksheet (a Spreadsheet::ParseExcel::Worksheet object)
Args : on set, new value (a Spreadsheet::ParseExcel::Worksheet
object or undef, optional)
_next_record
Title : _next_record
Usage :
Function: Navigates the underlying file to the next record.
We override this here in order to adapt navigation to data
in an Excel worksheet.
Example :
Returns : TRUE if the navigation was successful and FALSE
otherwise. Unsuccessful navigation will usually be treated
as an end-of-file condition.
Args :
_get_row_values
Title : _get_row_values
Usage :
Function: Get the values for the current line (or row) as an array in
the order of columns.
We override this here in order to adapt access to column
values to data contained in an Excel worksheet.
Example :
Returns : An array of column values for the current row.
Args :
perl v5.14.2 2012-03-02 Bio::SeqIO::excel(3pm)