Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extraction of .gz file using 7zip fails
Top Forums UNIX for Beginners Questions & Answers Extraction of .gz file using 7zip fails Post 302968195 by PikK45 on Saturday 5th of March 2016 02:58:21 AM
Old 03-05-2016
Wrench Extraction of .gz file using 7zip fails
Hi,

My target is to send a file created by Unix process to myself as an excel file. So I have used the below commands to achieve it.

Code:
tr -d '\t' < PROGRAM_CREATED_FILE | sed -e 's/\\//g' | awk 'BEGIN{FS=">"; OFS="\t"} '{$1=$1}1' > file.xls
gzip -9 file.xls
echo "test mail" | sendxchange -a "file.xls.gz" -s "Report" my_mail_id

After receiving the file on my mail box, I save it in Windows machine. I try to extract the archive using 7zip. It attempts to extract and says Data error in file.xls. File is broken

Need help on this.

Thanks
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

help on file extraction

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

date-extraction from a file in KSH

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

Extraction of various lines from a hugh file

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

Flat File Extraction

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

Data Extraction From a File

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

File extraction without awk

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

File Extraction

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

problem with file content extraction

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

data extraction from a file

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

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

py_xls2html

py_xls2html(1)						      General Commands Manual						    py_xls2html(1)

NAME

       py_xls2html - convert an Excel xls file to a html formatted file

SYNOPSIS

       py_xls2html  input-file

DESCRIPTION

       This manual page was written for the Debian distribution because the original program does not have a manual page.

       py_xls2html takes an Excel xls file as an argument and converts it to a html formatted file.  Output is sent to stdout.

       Additional utility scripts can be found in the tools/ directory.

OPTIONS

       This program does not take any command line options.

AUTHOR

       pyexcelerator and py_xls2html were written by Roman V. Kiseliov <roman@kiseliov.ru>.

       This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian system (but may be used by others).  Permission is granted
       to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any  later	version  published
       by the Free Software Foundation.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

SEE-ALSO
       pyexcelerator(1), py_xls2txt(1), py_xls2csv(1)

								 October 12, 2006						    py_xls2html(1)
All times are GMT -4. The time now is 05:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy