Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
Hi All,
I have a file with data as below:
A,FILE1_MYFILE_20130309_1038,80,25.60
B,FILE1_MYFILE_20130309_1038,24290,18543.38
C,FILE1_dsc_dlk_MYFILE_20130309_1038,3,10.10
A,FILE2_MYFILE_20130310_1039,85,110.10
B,FILE2_MYFILE_20130310_1039,10,12.10... (10 Replies)
Hi all I have a need of searching some pattern in file by month and then count unique records
D11
G11
R11 -------> Pattern available in file
S11
Jan$1 to $5 column contains some records in which I want to find unique
for this purpose I have written script like below
awk '/Jan/ ||... (4 Replies)
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
file:
1|12322|tow|
5|23422|pow|
6|23423|cow|
3|34324|how|
deletelines:
12322
23423
My command to delete line
while read NUM
do
awk -F"\|" '$2 !~ /`"$NUM"`/' file >file.back
mv file.back file
done<deletelines (3 Replies)
Hi all,
I have searched and searched, but I have not found a solution that quite fits what I am trying to do.
I have a long list of data in three columns. Below is a sample:
1,10,8
2,12,10
3,13,12
4,14,14
5,15,16
6,16,18
Please use code tags
What I need to do is as follows: If a... (4 Replies)
Discussion started by: bleedingturnip
4 Replies
LEARN ABOUT SUSE
quiz
QUIZ(6) BSD Games Manual QUIZ(6)NAME
quiz -- random knowledge tests
SYNOPSIS
quiz [-t] [-i file] [question answer]
DESCRIPTION
The quiz utility tests your knowledge of random facts. It has a database of subjects from which you can choose. With no arguments, quiz
displays the list of available subjects.
The options are as follows:
-t Use tutorial mode, in which questions are repeated later if you didn't get them right the first time, and new questions are presented
less frequently to help you learn the older ones.
-i Specify an alternative index file.
Subjects are divided into categories. You can pick any two categories from the same subject. quiz will ask questions from the first cate-
gory and it expects answers from the second category. For example, the command ``quiz victim killer'' asks questions which are the names of
victims, and expects you to answer with the cause of their untimely demise, whereas the command ``quiz killer victim'' works the other way
around.
If you get the answer wrong, quiz lets you try again. To see the right answer, enter a blank line.
Index and Data File Syntax
The index and data files have a similar syntax. Lines in them consist of several categories separated by colons. The categories are regular
expressions formed using the following meta-characters:
pat|pat alternative patterns
{pat} optional pattern
[pat] delimiters, as in pat[pat|pat]pat
In an index file, each line represents a subject. The first category in each subject is the pathname of the data file for the subject. The
remaining categories are regular expressions for the titles of each category in the subject.
In data files, each line represents a question/answer set. Each category is the information for the question/answer for that category.
The backslash character (``'') is used to quote syntactically significant characters, or at the end of a line to signify that a continuation
line follows.
If either a question or its answer is empty, quiz will refrain from asking it.
FILES
/usr/share/games/quiz The default index and data files.
BUGS
quiz is pretty cynical about certain subjects.
BSD May 31, 1993 BSD