08-19-2014
I usually use comma delimited output for Excel you can do this by setting OFS or adding commas to your print line.
Mike
This User Gave Thanks to Michael Stora For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have an excel file that have a random count of columns/fields and what im trying to do is to only retrieve all the rows under 2 specific field headers.
I can use the usually command for awk which is awk 'print{ $1 $2}' > output.txt, but the location of the 2 specific field headers is... (9 Replies)
Discussion started by: mdap
9 Replies
2. Shell Programming and Scripting
i have this file which has the following contents:
,-0.3000 ,-0.3000 ,-0.3000
,-0.9000 ,-0.9000 ,-0.9000
i would like to get this:
-0.3-0.9-0.3-0.9-0.3-0.9
so far i am trying:
awk '{for(i=1; i<=NF; i++) {printf("%f\n",$i)}}' test1 > test2
any help... (4 Replies)
Discussion started by: npatwardhan
4 Replies
3. Shell Programming and Scripting
i want sort columns with headers based on another file headers
file1
eg: i'm having an empty file with only coumn names like
lastname firstname title expirydate stlcno status etc...
another file with same column names and some other as well but in different order...
file2
eg:firstname... (2 Replies)
Discussion started by: Man83Nagesh
2 Replies
4. Shell Programming and Scripting
HELLO! This is my first post here! By the way, I think it is great that people do this.
My question:
I have two files, one is a .dilm and one is a .txt. It is my understanding that the .dilm file can be treated as a .txt file. I wrote another program where I was able to manipulate it as if it... (3 Replies)
Discussion started by: mehdib
3 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
i have a excel sheet with two columns as below.
column1 column2
100 100
200 300
300 400
400 400
500 600
i need to compare the values these two columns and the output should be printed in the third column...if these values are equal the output should be green and if these... (2 Replies)
Discussion started by: arunmanas
2 Replies
6. Shell Programming and Scripting
Hi list,
This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module.
I have an excel document with multiple tabs of data and graphs.
One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies
7. Shell Programming and Scripting
Hi,
I have a file like this
a b c
d e f
g h i
j k l
Case1:
I want to transpose the whole file
Output1
a d g j
b e h k
c f i l
Case2
Transpose a specific column - Say 3rd (6 Replies)
Discussion started by: jacobs.smith
6 Replies
8. UNIX for Dummies Questions & Answers
Dear all,
I have one file (see below) with more then 100 columns and 2500 rows, and need only column which has GType in label with Alphabets, please help me to remove these columns with numbers.
input file is
n.201.GType n-201.Theta n-201.R n_1.GType n_1.Theta n_1.R... (6 Replies)
Discussion started by: AAWT
6 Replies
9. Shell Programming and Scripting
Hi All,
I want to read an excel file.
PFA excel, I want to read the cloumn from A to G and the V to AH
starting from Row number 3.
Please help me on this. (7 Replies)
Discussion started by: Abhisrajput
7 Replies
10. Shell Programming and Scripting
Hi All,
I have below perl script which writes xml from .xls file.
Now i want to add below two conditions in this script :
1. to check if the the input .xls file has ony two columns , if more tahn two columns then script should pop up an error.
2. If there are two columns , then first column... (4 Replies)
Discussion started by: omkar.jadhav
4 Replies
LEARN ABOUT ULTRIX
nfslogsum
nfslogsum(8) Unsupported nfslogsum(8)
Name
nfslogsum - summarize nfswatch log file
Syntax
/usr/etc/nfslogsum [ -n ] [ -v ] [ logfile ]
Description
The command summarizes log files produced by the program. By default the log file is summarized; an alternate log file can be specified on
the command line.
Each log file can contain one or more log sessions, each indicated by a header which is printed when logging is turned on. For each log
session, tallies up the interval packet totals and prints out a one-page summary of the log session. Total packets and percentages are
tabulated for each category and displayed.
Options
-n Tells to read only the first n entries in the log file. This is useful for summarizing log files in cumulative ``chunks''.
-v Produces a ``verbose'' summary of the log file. In addition to the summary information printed as described above, a summary of how
many calls to each NFS procedure were made on each file system and individual file is printed. This summary information is divided
into three sections of six columns each. The columns are headed by the names of the NFS procedures; these are described briefly
below:
NULLPROC
Do nothing. This procedure is provided to allow server response testing and timing.
GETATTR
Get file attributes (for example, type, mode, number of links, owner's uid, owner's gid, size, access, modification and change
times). This procedure is used by the system call, as well as several others.
SETATTR
Set file attributes (mode, owner's uid, owner's gid, size in bytes, access and modification times). This procedure is used by sys-
tem calls such as
GETROOT
Get file system root. This procedure is obsolete, and has been replaced by a MOUNT Protocol procedure.
LOOKUP Look up file name. This procedure is used to obtain an initial file handle for use in current and future requests on that file, and
is used by many different system calls.
READLINK
Read from symbolic link. This procedure is used by the readlink system call, and by the kernel.
READ Read data from file. This procedure is used by the system call.
WCACHE Write to cache. Unused in the current NFS protocol revision.
WRITE Write data to file. This procedure is used by the system call.
CREATE Create file. This procedure is used by the and system calls.
REMOVE Remove file. This procedure is used by the system call.
RENAME Rename file. This procedure is used by the rename system call.
LINK Create link to file. This procedure is used by the system call.
SYMLINK
Create symbolic link to file. This procedure is used by the system call.
MKDIR Create directory. This procedure is used by the system call.
RMDIR Remove directory. This procedure is used by the system call.
READDIR
Read entries from directory. Generally only one READDIR call is needed per directory, since a variable number of entries can be
returned.
STATFS Get file system attributes (transfer size, block size, blocks in use, blocks free).
Restrictions
The nfslogsum command is extremely sensitive to the format of the log file produced by The log file should not be edited or changed before
feeding it to
See Also
nfswatch(8)
nfslogsum(8)