04-01-2014
Thanks for the reply and its working perfectly as expected.
Thanks again.
![Thumbsup Smilie](https://www.unix.com/images/smilies/thumb.gif)
Could you please explain how the code works.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have two files file1 and file2 delimited by semicolon,
And I want to compare column 2 and column3 of file1 to column3 and column 4 in file2.
file1
--------
abc;cef;155.67;143_34;
def;fgh;146.55;123.3;
frg;hff;134.67;;
yyy;fgh;134.78;35_45;
file 2
---------
abc;cef;155.09;;... (12 Replies)
Discussion started by: jerome Sukumar
12 Replies
2. Shell Programming and Scripting
Hello there,
I'm trying to write an awk program in bash shell with the following three input files:
File 1
1001 1 2 3
1002 4 5 6
1003 7 8 9
1004 10 11 12
File 2
1001 11 22 33
1002 44 55 66
1004 100 111 122
... (4 Replies)
Discussion started by: kbirde
4 Replies
3. Shell Programming and Scripting
- I am looking for different kind of awk solution which I don't think is mentioned before in these forums.
Number of rows in the file are fixed
Their are two columns in file1.txt
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10
I am looking for 3... (1 Reply)
Discussion started by: softwarekids23
1 Replies
4. Shell Programming and Scripting
I have two files which I would like to compare and then manipulate in a way.
File1:
pictures.txt 1.1 1.3
dance.txt 1.2 1.4
treehouse.txt 1.3 1.5
File2:
pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244
dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2... (1 Reply)
Discussion started by: linuxkid
1 Replies
5. Shell Programming and Scripting
Hello all,
Probably a very simple question, I am stuck with a small part of a code:
I am trying to do a comparison to get the maximum value of column 6 if columns 1, 4 and 5 of two or more rows match. Here is what I am doing:
awk -F'\t' '{if ($6 > a)a=$6}END{for (i in a) print i"\t"a}'
... (4 Replies)
Discussion started by: jaysean
4 Replies
6. Shell Programming and Scripting
Hi all,
I would like to compare a column in one file to a column in another file and when there is a match it prints the first column and the corresponding second column. Example
File1
ABA
ABC
ABE
ABF
File 2
ABA 123
ABB 124
ABD 125
ABC 126
So what I would like printed to a... (6 Replies)
Discussion started by: pcg
6 Replies
7. Shell Programming and Scripting
Hello All,
I am having a below requirement.
File1 contains
KEY|VIN|SEQUENCE|COST
101 | XXX111 | 1 | 234.22
234 | XXX111 | 2 | 134.32
444 | ABC234 | 1 | 100.22
555 | DFF611 | 1 | 734.82
FILE 2 Contains only VINs
XXX111
DFF611
Now if the VIN from file 1 is present in... (8 Replies)
Discussion started by: dinesh1985
8 Replies
8. Shell Programming and Scripting
Hello,
I couldn't find anything on the Forum that would help me to solve this problem. Could any body help me process below data using awk?
I have got two files:
file1:
Worker1: Thomas
Position: Manager
Department: Sales
Salary: $5,000
Worker2: Jason
Position: ... (5 Replies)
Discussion started by: killerbee
5 Replies
9. Shell Programming and Scripting
my files are as follows
fileA sepearated by tab /t
00 lieferungen
00 attractiop
01 done
02 forness
03 rasp
04 alwaysisng
04 funny
05 done1
fileB
funnymou120112
funnymou234470
mou3raspnhdhv
rddfgmoudone1438748
so all those record which are greater than 3 and which are not... (6 Replies)
Discussion started by: rajniman
6 Replies
10. Shell Programming and Scripting
Hi Guys,
I am having two requirement in one of my scripts. please help out to find a fast solution using AWK (since there is lot of data to be processed)
1) First snippet -
File1 has two columns and file2 has three columns
If any value of column 1 of file1 matches with column 1... (4 Replies)
Discussion started by: stormfield
4 Replies
diction(1) General Commands Manual diction(1)
NAME
diction, explain, suggest - Prints wordy sentences and looks them up in an interactive thesaurus.
SYNOPSIS
diction [-fpattern_file] [-k] [-ma] [-me] [-ml] [-ms] [-n] [file...]
explain
suggest
The diction command finds all sentences in an English language document that contain phrases from a database of bad or wordy diction. The
explain command is an interactive thesaurus for the English language phrases found by the diction command and only for those phrases.
The diction command reads from standard in if no file operand is provided.
The suggest command is a synonym for explain.
OPTIONS
Names a user-created pattern file to be used in addition to the default file. Passes the -k option to the deroff command. The -k option
keeps blocks of text specified nroff by requests or macros; for example, the request. Passes the -ma option to deroff. The -ma option
interprets nroff man macros only. Overrides the default nroff -ms macro package. Causes deroff to skip lists; should be used if a docu-
ment contains many lists of nonsentences. Overrides the default nroff -ms macro package. Suppresses use of the default file (used with
-f). Only the user-created pattern file is used.
DESCRIPTION
Each phrase found by the diction command is enclosed in [ ] (brackets). Because diction runs deroff before looking at the text, include
formatting header files as part of the input.
Before using the explain command, use the diction command to obtain a list of poorly worded phrases. When you use the explain command, the
system prompts you for a phrase and responds with a grammatically acceptable alternative. You can continue typing phrases, or you can exit
by pressing the End-of-File key sequence.
The explain command can also take input redirected from a file. No other command line arguments are valid.
NOTES
Use of nonstandard formatting macros may cause incorrect sentence breaks. In particular, diction does not understand -me.
FILES
Default pattern file. Thesaurus used by the explain command.
SEE ALSO
Commands: deroff(1), nroff(1)
diction(1)