Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Unix > Convert a delimited text file to excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Convert a delimited text file to excel

Reply to Message Icon

Name: Shirley Scribner
Date: February 20, 2002 at 09:18:30 Pacific
Comment:

Does anyone know if there's a tool available that can convert a semicolon delimited text file to an excel file?



Sponsored Link
Ads by Google

Response Number 1
Name: stefan caunter
Date: February 26, 2002 at 20:48:36 Pacific
Reply:

cat foo | tr ";" "," > bar
will convert the semicolons to commas.
excel will think it's a csv file and import it.


0
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Unix Forum Home


Sponsored links
Ads by Google


Results for: Convert a delimited text file to excel
Transfering text files to dos www.computing.net/answers/unix/transfering-text-files-to-dos/2269.html

Is there any standard model program for Solaris 2.6? www.computing.net/answers/unix/is-there-any-standard-model-program-for-solaris-26/506.html

How to convert text file to html www.computing.net/answers/unix/how-to-convert-text-file-to-html/4709.html