Solved

xls to dat

Posted on 2010-11-11
3
701 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 250 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 250 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

rdate is a Linux command and the network time protocol for immediate date and time setup from another machine. The clocks are synchronized by entering rdate with the -s switch (command without switch just checks the time but does not set anything). …
Fine Tune your automatic Updates for Ubuntu / Debian
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

679 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