UNIX for Dummies Questions & Answers

Hi,
Is there anyway to copy a certain column from the Ascii file into a column on an Excel sheet?


Thanks,

Not really all in one step.
Export a csv file from Excel.

Then add the column to the csv file using whatever unix tool is needed. I can't answer that part - I have not seen what is needed.

Bring the file back into Excel.

Note: this will not work with workbooks or other complex Excel data sets. Just single spreadsheets exported as a .csv file type. The file can be tab-delimited if that makes it easier to work with.

Also make sure you are using a standard delimiter and since you will likely be using CSV as your intermediate file format, then comma (,) is a good choice.

This might e a stupid question but... how do u export CSV from excel?

There are no stupid questions. But there are questions you should google first

That being said, in Excel, make sure you save your workbook first, and the click File | Save As... (if 2007 click the circle thingy at the top left and then Save As...). Change "Save as type:" to "CSV (Comma delimited)", give it a name, click save.

Remember that this will just be 1 worksheet, not the entire workbook, and it only saves data. Formulas, formats, etc., don't get saved in csv.