I have an excel file generated by system in windows. I am zipping it, transfering to unix and unzipping there. But i'm getting below output while unzipping.
When i copy this unzipped xls file to windows and open it, i couldn't see the properties of the file. Properties getting added to start of the file and i could see them alongwith some junk characters, when i open the file. And also complete first line is getting appended in a single cell.
I followed the below procedure.
1. Transfer the same zip file (without unzipping in unix) from Unix to Windows
2. Unzip it in Windows (I could see .xls file without any junk chars)
3. Manually create an xls file by copy-pasting the contents of the unzipped xls file
4. Zip it in Windows
5. Transfer the zip file to Unix
6. Unzip the file in Unix
Now the unzip output is different and copy back to windows and see, there are no junk charcters and file properties are shown properly.
Please advise what could be the issue, is it an issue while auto-generation of xls file by the system or it is while unzipping?
Thanks,
Ajay
---------- Post updated 08-26-10 at 09:50 AM ---------- Previous update was 08-25-10 at 10:34 AM ----------
Hi team,
I got the solution. It is working fine if i do not use -a flag while unzipping.
Hi
i have a problem in my job
i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand
cat xxx.xls > xxx.txt
Do you have eny idea?
PS: sorry for my english
Thanks!! (4 Replies)
How i print just only the file name in the zip file.
unzip -l AAC_20130930_v13.xml.zip
Archive: AAC_20130930_v13.xml.zip
Length Date Time Name
-------- ---- ---- ----
62665745 11-19-13 10:43 AAC_20130930_v13.xml
-------- -------
62665745 ... (2 Replies)
Hi,
I have a zip file created on a Linxux server that I need to extract on a Windows machine...
The zip file containing folders with the same name but they each have a different case, one if camel case and the other is just capitalised. When I extract using 7zip, I get prompted if I want to... (3 Replies)
I wrote my unix archive script to move the zip files from unix input folder to windows folder,the zip files got successful transfered but while iam unzipping them in windows folder a new line is getting appended in my file..
how can i remove that new line..? (6 Replies)
Hi,
I don't have enough space on my Unix Box. So, I can't unzip the file and check the size of the file. So, I need to know, Is there any command, to check, how much the unzipped file takes after unzipping. Thanks in Advance. (4 Replies)
Hi
Howto view gzipped files with name file.gz.$DATE on a Solaris box (without unzipping first)
$ ls -lrt
total 4477
-rwxrwxr-x 1 oracle dba 569745 Apr 4 19:45 4_person2profileCon.txt.gz.04.04.11*
-rwxrwxr-x 1 oracle dba 3783 Apr 4 19:45... (4 Replies)
Hi All,
I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box .
I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
I am transferring a large .zip file (20 GB) from an NT server to HP-UX and Solaris servers. Originally I tried to use info-zip's unzip, but I found out pretty quickly that it does not support files over 4GB. Any suggestions on how to work around this problem? Different decompression utility?... (9 Replies)