12-31-2014
thanks XL and masters excelente very fine solution
happy hollydays
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have many text file reports generated by a Information Assurance tool that I need to get into a .CSV format or Excel tab delimited format. I want to use sed or awk to grab all the information in the sample text file below and create column headings:Risk ID, Risk Level, Category, Description, How... (5 Replies)
Discussion started by: Bjoeboo
5 Replies
2. Shell Programming and Scripting
hi i need help in my script
i have a file
a.txt
3,4,5,13
6,7,8,45
9,0,1,67
i want to add 2nd and 3rd colum like o/p will be by adding all values of colum2(4+7+0) and colum 3(5+8+11)
o/p:
colum 2: 11
colum 3: 14 (6 Replies)
Discussion started by: anish19
6 Replies
3. Shell Programming and Scripting
i have a file
a.txt
12345,20
34567,10
23123,50
123456,45
how to find lines which hav 2nd entry greater than 40
o/p
23123,50
123456,45
pls help to get o/p (5 Replies)
Discussion started by: devesh123
5 Replies
4. Shell Programming and Scripting
Dear Unix users,
I have a (I think simple) question;
I have a file (out.dat) like below,
the file contains some line which include 'LOS' string.
.
LOS 46.5360 91.0220 200708.2515.4900. 5400 64 1100010
.
.
I would like to delete the points in 4th... (4 Replies)
Discussion started by: mgunduz
4 Replies
5. UNIX for Dummies Questions & Answers
Hi all,
I have two files:
file one (9 rows, 3 columns):
A 1 x1
B 2 f1
C 3 f3
D 4 u5
E 5 l9
F 6 h6
G 7 g4
H 8 r4
I 9 s2
file two (4 rows, 1 column):
A
B (2 Replies)
Discussion started by: anjas
2 Replies
6. UNIX for Dummies Questions & Answers
Hello Everyone,
My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row.
I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table.
Please help.
Thanks &... (5 Replies)
Discussion started by: ahsan.asghar
5 Replies
7. Linux
Dear Gurus,
When i ran vmstat, i am getting swpd value,but si, and so beneath the swap is o, My doubt what is the difference between these values,i,e swpd and si and so
OS is OEL 5.5
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r b swpd free buff cache... (2 Replies)
Discussion started by: dave234
2 Replies
8. Shell Programming and Scripting
Hi,
I want a flat file(pipe delimited) to be sorted based on 2nd column only. Below is input file to be sorted.
AVERS|K50034|A|Y|N|N|Y|Y|Y|||N|N
AVERS|K50035|A|Y|N|N|Y|Y|Y|||N|N... (11 Replies)
Discussion started by: Nikhath
11 Replies
9. Shell Programming and Scripting
Hi All
I want to findout coloum number where value is >0 from below string
Can we do using awk or any command ?
Thanks in advance
... (7 Replies)
Discussion started by: aaysa123
7 Replies
10. Shell Programming and Scripting
Source file 1
335 R1-snapfound 0098F RDFType:R1 R2-Dev R2-snapfound ,010C0 RemoteSymmetrixID:345
335 R1-snapfound 00990 RDFType:R1 R2-Dev R2-snapfound ,010C1 RemoteSymmetrixID:345
335 R1-snapfound 009C0 RDFType:R1 R2-Dev R2-snapfound ,009C1 RemoteSymmetrixID:345
335 R1-snapfound 009C1... (5 Replies)
Discussion started by: ranjancom2000
5 Replies
LEARN ABOUT OPENSOLARIS
comm
comm(1) User Commands comm(1)
NAME
comm - select or reject lines common to two files
SYNOPSIS
comm [-123] file1 file2
DESCRIPTION
The comm utility reads file1 and file2, which must be ordered in the current collating sequence, and produces three text columns as output:
lines only in file1; lines only in file2; and lines in both files.
If the input files were ordered according to the collating sequence of the current locale, the lines written will be in the collating
sequence of the original lines. If not, the results are unspecified.
OPTIONS
The following options are supported:
-1 Suppresses the output column of lines unique to file1.
-2 Suppresses the output column of lines unique to file2.
-3 Suppresses the output column of lines duplicated in file1 and file2.
OPERANDS
The following operands are supported:
file1 A path name of the first file to be compared. If file1 is -, the standard input is used.
file2 A path name of the second file to be compared. If file2 is -, the standard input is used.
USAGE
See largefile(5) for the description of the behavior of comm when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).
EXAMPLES
Example 1 Printing a list of utilities specified by files
If file1, file2, and file3 each contain a sorted list of utilities, the command
example% comm -23 file1 file2 | comm -23 - file3
prints a list of utilities in file1 not specified by either of the other files. The entry:
example% comm -12 file1 file2 | comm -12 - file3
prints a list of utilities specified by all three files. And the entry:
example% comm -12 file2 file3 | comm -23 -file1
prints a list of utilities specified by both file2 and file3, but not specified in file1.
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of comm: LANG, LC_ALL, LC_COLLATE,
LC_CTYPE, LC_MESSAGES, and NLSPATH.
EXIT STATUS
The following exit values are returned:
0 All input files were successfully output as specified.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWesu |
+-----------------------------+-----------------------------+
|CSI |enabled |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO
cmp(1), diff(1), sort(1), uniq(1), attributes(5), environ(5), largefile(5), standards(5)
SunOS 5.11 3 Mar 2004 comm(1)