Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert aix file into csv or xls spreadsheet.

Status
Not open for further replies.

strikelit

MIS
Sep 10, 2003
88
US
I have an AIX file and would like to convert the contents into a CSV or XLS spreadsheet. How can I do this ?
 
CSV is just a text file with Comma Separated Values. If the file is a text file, you can use whatever means possible to insert the commas...
A sample portion of your file posted here might also help...

HTH,

p5wizard
 
I believe you are confused, AIX is NOT a file type. AIX is the Unix variant created by IBM. Your question would be similar to "I have a Windows file that I need to convert into a CSV or XLS spreadsheet." Can you understand how it doesn't make sense?

To find out what the contents of a file are in AIX, simply use the "file" command.
[blue]> file filename[/blue]

This will let you know if it is text, a directory, an executable, binary data, or a symbolic link (all of these are considered "files" in AIX).

Einstein47 (Starbase47.com)
“PI is like love - simple, natural, irrational, endless, and very important“
 
If the file is alreayd seperated by any delimeter other than commas then you can easily do it through excel without worrying about how to do it in AIX (though it can be done through awk or sed commands in AIX)

Regards,
Khalid
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top