Add values to file in 2 new columns Post: 303044450

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to flip values of two columns and add an extra column

Hi guys, Couldn't find the solution of this problem. Please Help! I have a file- Input_File TC200232 92 30 TC215306 2 74 TC210135 42 14 I want an output file in which if column2>column3, the values are swapped and an additional column with value Rev_Com is...

2. UNIX for Dummies Questions & Answers

combine the values from the first two columns within a file

Hello everybody, I have a text file containing 10,000 rows and 5000 columns. The values are separated by a tab. Ex. file_ex.ped 1 mike 0 0 2 1 A A G G C T A G 1 jack 0 0 2 2 T A G T C A A C 1 Mary 0 0 1 2 A T G C A T G C ... I would like a out put file 1 mike 0 0 2 1 AA GG CT AG 1...

3. Shell Programming and Scripting

Math operations with file columns values.

Hello everybody, I have some large files containing statistical data. The data is stored in the following generic format: >cat my_file 1, 2, 3 1, 2, 3 1, 2, 3 > The values of columns no.2 and 3 are expressed in bytes. I would like to transform them in Megabytes, by dividing them with...

4. Shell Programming and Scripting

Copy values from columns matching in those in second file.

Hi All, I have two sets of files. Set 1: 100 text files with extension .txt with names like 1.txt, 2.txt, 3.txt until 100.txt Set 2: One big file with extension .dat The text files have some records in columns like this: 0.7316431 82628 0.7248189 82577 0.7248182 81369 0.7222999...

5. UNIX for Dummies Questions & Answers

Subtracting values from 2 columns in a file

Hello, I have a file with 5 columns that looks like this: A1BG chr19 + 58863335 58866549 A1BG chr19 - 58858171 58864865 A2LD1 chr13 - 101182417 101186056 A2LD1 chr13 - 101182417 101241046 A2M chr12 - 9220303 9268558 A2ML1 ...

6. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing...

7. Shell Programming and Scripting

for uniq entries add values in corresponding columns

Hi, I have a file as listed below.. What I want to get is for each unique value in column 1 the corresponding values in the rest of the columns should be summed up.. AAK1 0 1 0 11 AAK1 0 0 1 1 AAK1 0 0 1 2...

8. Shell Programming and Scripting

Add the values in second and third columns with group by on first column.

Hi All, I have a pipe seperated file. I need to add the values in second and third columns with group by on first column. MYFILE_28012012_1115|47|173.90 MYFILE_28012012_1115|4|0.00 MYFILE_28012012_1115|6|22.20 MYFILE_28012012_1116|47|173.90 MYFILE_28012012_1116|4|0.00...

9. Shell Programming and Scripting

Add values in 2 columns and subtract from third

Hi All, I have a file with thousands of lines in the following format, where Field1=First 8 characters Field2-9-16 characters Field3=17-26 characters I need to add Field 1 and Field2 and subtract the result from Field 3. Field3=Field3 - (Field1 + Field2) 0012.00 0010.00 0001576.53...

10. UNIX for Beginners Questions & Answers

Awk: compare values in two columns of the same file

I'm trying to learn awk, but I've hit a roadblock with this problem. I have a hierarchy stored in a file with 3 columns: id name parentID 4 D 2 2 B 1 3 C 1 1 A 5 I need to check if there are any values in column 3 that are not represented anywhere in column 1. I've tried this: awk '{arr;}...

LEARN ABOUT DEBIAN

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/bsdgames/quiz  The default index and data files.

BUGS

     quiz is pretty cynical about certain subjects.

BSD
								   May 31, 1993 							       BSD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to flip values of two columns and add an extra column

Discussion started by: smriti_shridhar

2. UNIX for Dummies Questions & Answers

combine the values from the first two columns within a file

Discussion started by: Unilearn

3. Shell Programming and Scripting

Math operations with file columns values.

Discussion started by: fabian23

4. Shell Programming and Scripting

Copy values from columns matching in those in second file.

Discussion started by: shoaibjameel123