06-21-2011
Copy the file from your unix system to local windows box. Once done then open it in excel will be enough. in Excel go to Data -> Text to Columns -> Delimited -> and under Other type "|".
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i am currently using a unix environment and will be constantly receiving documents in excel format(.xls) my question is
is there any tools that will do auto convertion of data in the excel doc into .txt?
ps.. my job are mainly for batch processing. thus it would be great if no manual work is... (2 Replies)
Discussion started by: swakoo
2 Replies
2. UNIX for Dummies Questions & Answers
Folks;
I'm writing a shell script to extract some field out of log file to a text file which i can convert/open in Excel sheet.
I gave names to the fields like (Editor_name, Owner, etc..) to be in the top of the Excel sheet.
When i open the file using Excel sheet i see these filed names fine on... (2 Replies)
Discussion started by: moe2266
2 Replies
3. Shell Programming and Scripting
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
4. Windows & DOS: Issues & Discussions
I have a .csv file, when i open it in excel sheet the content is getting displayed in scientific notation (E+e.) , now inorder to remove tht i have appended ' (single quote) infront of the number. This is working fine. But when i open in excel the ' single quote is appearing before the number. My... (1 Reply)
Discussion started by: dvrraju
1 Replies
5. Windows & DOS: Issues & Discussions
Hello,
I have received very much needed help in the past from this forum and hope that someone can assist me once more. I am in the military and I am tracking classroom specific training for each one of our units per sailor in that unit. I am attaching the spreadsheet for your review. There are... (5 Replies)
Discussion started by: Maggiepie
5 Replies
6. UNIX for Dummies Questions & Answers
Hello everybody. I am new here and hoping someone is willing to help. I just want to know if anyone can tell me how it would be possible to combine two separate rows in excel while adding certain pieces of information and keeping others the same.
Here is what I mean. I want to combine the same... (1 Reply)
Discussion started by: blubiz2
1 Replies
7. Shell Programming and Scripting
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies
8. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
9. Shell Programming and Scripting
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
10. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
LEARN ABOUT X11R4
fs_whereis
FS_WHEREIS(1) AFS Command Reference FS_WHEREIS(1)
NAME
fs_whereis - Reports each file server housing a file or directory
SYNOPSIS
fs whereis [-path <dir/file path>+] [-help]
fs whe [-p <dir/file path>+] [-h]
DESCRIPTION
The fs whereis command returns the name of each file server machine that houses the volume containing each directory or file named by the
-path argument.
OPTIONS
-path <dir/file path>+
Names each AFS file or directory for which to return the host file server machine. Partial pathnames are interpreted relative to the
current working directory, which is also the default value if this argument is omitted.
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The output includes a line for each specified directory or file. It names the file server machine on which the volume that houses the
specified directory or file resides. A list of multiple machines indicates that the directory or file is in a replicated volume.
Machine names usually have a suffix indicating their cell membership. If the cell is not clear, use the fs whichcell command to display the
cell in which the directory or file resides. To display the cell membership of the local machine, use the fs wscell command.
EXAMPLES
The following example indicates that volume housing the directory /afs/abc.com resides is replicated on both "fs1.abc.com" and
"fs3.abc.com":
% fs whereis -path /afs/abc.com
File /afs/abc.com is on hosts fs1.abc.com fs3.abc.com
PRIVILEGE REQUIRED
None
SEE ALSO
fs_whichcell(1), fs_wscell(1)
COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 FS_WHEREIS(1)