Solved

xls to dat

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Currently, there is not an RPM package available under the RHEL/Fedora/CentOS distributions that gives you a quick and easy way to allow PHP to interface with Oracle. As a result, I have included a set of instructions on how to do this with minimal …
Introduction We as admins face situation where we need to redirect websites to another. This may be required as a part of an upgrade keeping the old URL but website should be served from new URL. This document would brief you on different ways ca…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now