Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

xls to dat

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
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…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

839 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