Improve company productivity with a Business Account.Sign Up

x
?
Solved

xls to dat

Posted on 2010-11-11
3
Medium Priority
?
711 Views
Last Modified: 2012-05-10
Hello,

I have an Excel file which I get from an ftp site. I'm trying to moving it to a .dat file, so I can later process it. The problem is that the .dat file is full a garbage. Is there a way yo clean all the garbage from the .data file and just leave the original data.

Thanks!

Alex
0
Comment
Question by:paquicuba
3 Comments
 
LVL 3

Accepted Solution

by:
njovin earned 1000 total points
ID: 34112568
I'm not sure I follow what you mean by .DAT file.  Are you just trying to get the excel data out to plain text?  If so you should probably save it as TXT or CSV and then rename it to .DAT
0
 
LVL 68

Assisted Solution

by:woolmilkporc
woolmilkporc earned 1000 total points
ID: 34113019
If you don't have MS Excel available to save the Excel tables as text or CSV you need a converter, e.g. this (payable) one -
http://www.ozgrid.com/Services/convert-excel-text-txt.htm
Search the web, maybe there are free converters out there.
wmp
0
 
LVL 23

Author Closing Comment

by:paquicuba
ID: 34113069
Thanks!
I installed xls2csv --it's working like a charm!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have written articles previously comparing SARDU and YUMI.  I also included a couple of lines about Easy2boot (easy2boot.com).  I have now been using, and enjoying easy2boot as my sole multiboot utility for some years and realize that it deserves …
Often times it's very very easy to extend a volume on a Linux instance in AWS, but impossible to shrink it. I wanted to contribute to the experts-exchange community a way of providing a procedure that works on an AWS instance. It can also be used on…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question