Visit Our UNIX and Linux User Community


From Ascii files to Excell


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers From Ascii files to Excell
# 1  
Old 08-19-2009
From Ascii files to Excell

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


Thanks,
# 2  
Old 08-19-2009
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.
# 3  
Old 08-24-2009
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.
# 4  
Old 08-24-2009
Quote:
Originally Posted by jim mcnamara
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.


This might e a stupid question but... how do u export CSV from excel?
# 5  
Old 08-24-2009
There are no stupid questions. But there are questions you should google first Smilie

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.
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #1006
Difficulty: Medium
In calculus and most other branches of mathematics beyond practical geometry, angles are universally measured in degrees.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Trimmean of Excell in awk

Anyone know how we can implement excel trimmean avg in Unix. possible by AWK Sample File scr1 100 scr1 2000 scr2 320 scr1 50 scr1 10 scr2 2 scr2 220 scr1 4234 scr2 2435 scr2 2 scr3 345 scr2 356 expected Output, which was using =trimmean(scr1 values, ignore 50% of values from... (8 Replies)
Discussion started by: mychbears
8 Replies

2. Shell Programming and Scripting

PERL excell scripting

Hi, At the minute I am using a script to gather weekly SAR stats and put them into an excel scpreadsheet using perl. I then get that spreadsheet and manually add in a chart on a new worksheet, Can i add this step into the script? and if so how? here is the part of my script that creates the... (9 Replies)
Discussion started by: Bdoydie
9 Replies

3. UNIX for Advanced & Expert Users

line endings help of non-ASCII files

When you are dealing with ASCII files it easy to check on line endings type. You can just use the file command. You are not always lucky enough to be dealing with ASCII files. So in the cases that you don't have ASCII files how can you check what type of line endings you have? Please list all... (5 Replies)
Discussion started by: cokedude
5 Replies

4. UNIX for Dummies Questions & Answers

Finding and using (only) ASCII files.

Hi, I had to do something I could do in a way that worked fine, but I'm still wondering if there's a shorter way (which I think there is)... I had to find only the ASCII files of a directory, and then work with them (that is, not only showing on screen) What I did was ls | xargs... (4 Replies)
Discussion started by: Casey
4 Replies

5. Shell Programming and Scripting

how to write into an Excell

Hello All, I have a query inside a shell script and it will retun a 1000 rows result set. how can i take the output into an excel file from the script for better viewing the results. Thanks, Sateesh (4 Replies)
Discussion started by: kotasateesh
4 Replies

6. UNIX for Dummies Questions & Answers

word count ascii files

how do I display the total number of words in a file which is of the type ascii text (1 Reply)
Discussion started by: madtim
1 Replies

7. UNIX for Dummies Questions & Answers

String substitutions in ASCII files -

We need to scramble data in a number of ASCII files. Some of these files are extremely large (1.2 GB). By scrambling, I mean that we need to substitute certain strings, which number around 400, with scrambled strings. An example has been given below If "London" occurs in the file, then it... (2 Replies)
Discussion started by: SanjivNagraj
2 Replies

8. UNIX for Advanced & Expert Users

viewing binary files in ASCII

Hi, How to view binary files in ASCII format.???????????????? Bye (2 Replies)
Discussion started by: manjunath
2 Replies

9. Programming

open ASCII files

Anyone knows how to open an ASCII file by using C Thanks :D (2 Replies)
Discussion started by: Wing m. Cheng
2 Replies

10. UNIX for Dummies Questions & Answers

ASCII Files

Can you pls help on writing ASCII files? For example, how to you put SUPPLIER NO and NAME in an ASCIIfile? (1 Reply)
Discussion started by: yialousa
1 Replies

Featured Tech Videos